I have a Customer management appsheet - there’s Organizations, people and locations, a table for each.
In my app, when I go to an Organization, and then add a location, I would like to select the person who corresponds with a given location.
My problem is the list of people is showing ALL people from ALL organizations.
I would like to drop down a list of ONLY the people who belong to the selected organization.
Is SHOWIF what I should use?
I keep tripping on this one.
Put this in the Valid_If for the column: SELECT(People[keyCol],AND([Organization]=[_THISROW].[Organization], [Location]=[_THISROW].[Location]))
User | Count |
---|---|
38 | |
27 | |
23 | |
23 | |
13 |