Checking a box using an IF statement with AND and OR

deb_63_hydracor

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!!

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!