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.