Looking to Show If a primary view only if two criteria are valid. I have a list of members emails (Member_ID) and dates they have signed up for something. I’m trying to show a “CheckIn” form only if their email address is present on the schedule and the date in the same row is = Today.
AND(Lookup(“Member_ID”,“Charter Scheduling”,“Member Email”,“Member Email”)=USEREMAIL(),Lookup(“Member_ID”,“Charter Scheduling”,“Member Email”,“Start Date”)=Today())
And the yellow error:
This formula is not evaluated in the context of a row, so column values are not available.
It allows the formula without red error but the view is not visible after sync. Thoughts?