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

Question

Question

New Designer Formula Assistance Needed

asked on June 23

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 on June 23

Try this formula:

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

2 0
replied on June 23

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

1 0
replied on June 23

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.