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

Options
Kitty
Kitty ✭✭✭✭✭

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!

Tags:

Best Answers

Answers