You are viewing limited content. For full access, please sign in.

Question

Question

New Designer Formula Assistance Needed

asked one day ago

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!

0 0

Answer

SELECTED ANSWER
replied one day ago

Try this formula:

=IF(COUNTIF(Attendance_Table.ConditionMet, "TRUE") > 0, "TRUE", "FALSE")

2 0
replied one day ago

@████████ Works great, thanks!

1 0
replied one day ago

Perfect! No problem at all, happy to help. :)

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.