Checking a box using an IF statement with AND and OR

Hi,

I'm trying to check a box if the Rounding status is any of (4 options) but EHR status is not "Operational."

This formula works before I add the "AND EHR status is not operational" part of the statement:

=IF([Experiencia Rounding Status]@row = "Operational", 1, IF([Experiencia Rounding Status]@row = "Needs Post Launch Review", 1, IF([Experiencia Rounding Status]@row = "Post Launch Call Scheduled", 1, IF([Experiencia Rounding Status]@row = "Adding a Service", 1))))

When I try to add the AND statement, I'm getting an error:

=IF(OR(AND(EHR Integration Status@row <>"Operational"),([Experiencia Rounding Status]@row = "Operational", [Experiencia Rounding Status]@row = "Needs Post Launch Review", [Experiencia Rounding Status]@row = "Post Launch Call Scheduled", [Experiencia Rounding Status]@row = "Adding a Service", 1, ))))

Thanks for your help!!

Find more posts tagged with

Accepted answers

All comments

Mike TV

@deb_63_hydracor

=IF(AND([Experiencia Rounding Status]@row = "Operational", [EHR Integration Status]@row <> "Operational"), 1, IF(AND([Experiencia Rounding Status]@row = "Needs Post Launch Review", [EHR Integration Status]@row <> "Operational"), 1, IF(AND([Experiencia Rounding Status]@row = "Post Launch Call Scheduled", [EHR Integration Status]@row <> "Operational"), 1, IF(AND([Experiencia Rounding Status]@row = "Adding a Service", [EHR Integration Status]@row <> "Operational"), 1))))

deb_63_hydracor

That worked. Thanks!

deb_63_hydracor

Hi Again,

Rather than checking a box, I'm thinking of doing a COUNTIF instead. I modified the formula you gave me above but it is giving me an error:

=COUNTIFS(AND([Experiencia Rounding Status]@row = "Operational", [EHR Integration Status]@row <> "Operational"), 1, IF(AND([Experiencia Rounding Status]@row = "Needs Post Launch Review", [EHR Integration Status]@row <> "Operational"), 1, IF(AND([Experiencia Rounding Status]@row = "Post Launch Call Scheduled", [EHR Integration Status]@row <> "Operational"), 1, IF(AND([Experiencia Rounding Status]@row = "Adding a Service", [EHR Integration Status]@row <> "Operational")))))

Thanks for your help!

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.