Combining Valid_if expressions?
Hi, I am using the following expression as a Valid_if column constraint to generate a list of values from another table, however the resulting list is too broad. I need to filter/narrow down that list based on the value of another column in the same table (Acq. Chart). How would I go about doing that?
Here is the expression I am currently using: IN( [_THIS], SELECT(Acq. Chart[Target], [_THISROW].[Goal ID] = [Goal ID]))
I am new to appsheet. Any help would be greatly appreciated.