Looking for a solution to this within Stacker because the tables are in separate bases and not synced (and trying to avoid a sync for reasons I won’t get into).
Main record is linked to multiple sub-records from another table, each with a value.
On the main record, if any of those related records has a value >X, the main record is marked false.
I’ve tried rolling up the max value, but that rollup field doesn’t seem accessible from a formula,
I’ve tried marking each record true/false on the table, and then doing a lookup in Stacker of those values, but Stacker doesn’t support any kind of includes() or contains() function
Any other ideas?