Solved: Show_If Statement not in proper row context - Page 2

Laurene_Haynesw · 08-19-2020 08:32 AM

In the app a user can register for a particular board. There are a total of 3 boards that they can register for. I have the following expression AND(CONTAINS([Board] = “C Note”, [Email Address]) = False, CONTAINS([Board] = “Monkey”, [Email Address]) = False, CONTAINS([Board] = “Monkey”, [Email Address]) = False) in the Show_If of the board assignment table. This, however, states: This formula is not evaluated in the context of a row, so column values are not available. How should I rewrite this formula to be in the proper context?

Marc_Dillon

I think I understand. Try this expression in the show_if field

IN( {board name for view} , SELECT( Board Registrations[Board] , [Email Address] = USEREMAIL() )

Replace {board name for view} with the name of the board associated with each view.
Replace “Board Registrations” with whatever is the name of the table that you just posted example data from.

Also reference:

View solution in original post