IF-OR-AND Formula for Multiple Scenarios

Help! I need to finalize a formula to return a value of "Yes" if one of two AND statements are true. I am not getting an error with the formula below, but it is not returning a value of Yes or No:

=IF(OR(AND([Send to Compliance?]@row = 1, [Finance Approval Status]@row = "Approved", (AND([Send to Compliance?]@row = 0, [Finance Approval Status]@row = "Approved")), "Yes", "No")))

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Your parenthesis are off. Make sure you are keeping your AND statements separate within the OR statement.

=IF(OR(AND(..........), AND(..........)), "Yes", "No")

Paul Newcome

This goes back to my first response about the parenthesis being off. Double check your syntax.

All comments

Paul Newcome

Your parenthesis are off. Make sure you are keeping your AND statements separate within the OR statement.

=IF(OR(AND(..........), AND(..........)), "Yes", "No")

Tony Fronza

Thanks @Paul Newcome! That worked :)

Tony Fronza

@Paul Newcome one last question. The formula returns "No" when one of the AND statements is complete. Do I have the right logic? I want it to return Yes if either scenario applies and No if neither applies.

Paul Newcome

What is the logic you want it to follow?

Tony Fronza

@Paul Newcome I want to follow the logic below:

Return "Yes" if EITHER of the following is accurate:

The box is checked for "Send to Compliance" AND "Finance Approval Status" is Approved
The box is unchecked for "Send to Compliance" but "Finance Approval Status" is Approved

If not, then return "No."

=IF(OR(AND([Send to Compliance?]@row = 1, [Finance Approval Status]@row = "Approved", (AND([Send to Compliance?]@row = 0, [Finance Approval Status]@row = "Approved")), "Yes", "No")))

Paul Newcome

So really... It doesn't matter whether the [Send To Compliance] box is checked or unchecked as long as the [Finance Approval Status] is "Approved"?

=IF([Finance Approval Status]@row = "Approved", "Yes", "No")

Tony Fronza

@Paul Newcome the issue is that I have another workflow that triggers from the checkbox. In the other workflow, our Compliance team is notified when the box is checked AND Financial Approval is "Approved." But, I think I just thought of a solution that uses a status in another column to trigger this. Stay tuned...

Tony Fronza

@Paul Newcome I adjusted the formula with an OR/AND based on a new set of criteria to be clearer. But, I'm receiving an error message:

=IF(OR(AND([Compliance Approval Status]@row = "N/A", [Finance Approval Status]@row = "Approved", AND([Compliance Approval Status]@row = "Approved", [Finance Approval Status]@row = "Approved", "Yes", "No")))))

Paul Newcome

This goes back to my first response about the parenthesis being off. Double check your syntax.

Tony Fronza

Thanks @Paul Newcome! I corrected it and it now works:

=IF(OR(AND([Compliance Approval Status]@row = "N/A", [Finance Approval Status]@row = "Approved"), AND([Compliance Approval Status]@row = "Approved", [Finance Approval Status]@row = "Approved")), "Yes", "No")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.