I need some assistance with a formula outside a table. The row formula is working, but now I need something to evaluate the results of all of the ConditionMet values and see if any of them are TRUE so that I can do some routing of the form later.
The table will be populated by lookup so the number of rows will vary and the value in the Attended column will be chosen by the instructors (it defaults to "Yes").
If ANY of the rows are values not equal to "Yes" then I want the Exceptions field to show True so I can setup an exception Gateway.
I've tried both of these formulas, and both give me the same error displayed above once I select any value from the Attended dropdown.
=OR(Attendance_Table.ConditionMet)
=EQ(OR(Attendance_Table.ConditionMet),"TRUE")
Any insight would be greatly appreciated!