IF/OR/NOT formula: What am I doing wrong?

There are three criteria that programs must meet before we can release the hold on their reservations:

1) Covid safety plan in place

2) Approval to bring minors to campus

3) Housing plans in place

Here is the formula I'm working on, which is returning an "unparseable" error message:

=IF(OR(NOT([COVID Safety Plan]@row = "Not Yet Uploaded", OR[Minors Upload]@row= "Not Yet Uploaded", OR[Housing Upload]@row = "Not Yet Uploaded"))), "Release Hold", "Hold"

I will be setting up workflow according to the "Hold Status" column (activated if the status changes to "Release Hold").

Thanks in advance!

Mary

P.S. There are more options than "Not Yet Uploaded" and "Uploaded", so I have to go with the "NOT" in this case.

Find more posts tagged with

Formulas

Accepted answers

Jason Duryea

Sorry, I goofed on the previous formula...the corrected one is below.

=IF(AND(NOT([COVID Safety Plan]@row = "Not Yet Uploaded"), NOT([Minors Upload]@row = "Not Yet Uploaded"), NOT([Housing Upload]@row = "Not Yet Uploaded")), "Release Hold", "Hold")

All comments

Jason Duryea

If all three criteria are required then the formula should be using the AND() function, not the OR() function. The AND() or OR() functions only need to be used once, with all criteria separated with a comma as shown below.

=IF(AND(NOT([COVID Safety Plan]@row = "Not Yet Uploaded", [Minors Upload]@row = "Not Yet Uploaded", [Housing Upload]@row = "Not Yet Uploaded")), "Release Hold", "Hold")

Using a single AND() will require all three criteria to be true for the IF() statement to result in "Release Hold". If ANY criteria doesn't match, then it will result in "Hold".

Jason Duryea

Sorry, I goofed on the previous formula...the corrected one is below.

=IF(AND(NOT([COVID Safety Plan]@row = "Not Yet Uploaded"), NOT([Minors Upload]@row = "Not Yet Uploaded"), NOT([Housing Upload]@row = "Not Yet Uploaded")), "Release Hold", "Hold")

Mary Ayers

Thank you, Jason! That did it! :)

Mary

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.