How do I write a nested IF formula to count a location if 1 of 2 trigger answers appears in a field?

Kitty · 07/15/21

This is the formula I tried, but I'm missing something.

=IF(OR[Location Status]@row = "Active", "Operational", 1, 0)

Thank you for your help!

Garrett Henke · 07/15/21

Hi @Kitty, Your original formula is very close to being correct. Here is the fix

=IF(OR([Location Status]@row = "Active", [Location Status]@row = "Operational"), 1, 0)

Kitty · 07/15/21

YES! That worked! Thank you SO VERY MUCH!!!

Kitty S.

Garrett Henke · 07/15/21

Hi @Kitty, Your original formula is very close to being correct. Here is the fix

=IF(OR([Location Status]@row = "Active", [Location Status]@row = "Operational"), 1, 0)

Kitty · 07/15/21

YES! That worked! Thank you SO VERY MUCH!!!

Kitty S.

Best Answers