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.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |