Solved: REF_ROWS question - Page 2

MikeJones · 12-17-2022 06:57 AM

I have 2 tables, "Bookings" and "Staff" For the "Staff" table AppSheet has auto generated a list column in the "Staff" view with the following formula REF_ROWS("Bookings", "Skipper") ie Show me all the bookings where the Skipper field matches the Staff ID

There is another field on the Bookings table called "Crew" Is there a way to get all the bookings where either the skipper field OR the Crew field matches the Staff ID

dbaum

There may be more elegant solutions depending on your table relationships, but one basic approach should be:

[Related Booking IDs] + SELECT(Bookings[Booking ID], [Crew] = [_THISROW].[Staff ID])

View solution in original post