Formula help

Lori Khoury
Lori Khoury ✭✭✭✭✭
edited 09/21/22 in Formulas and Functions


Just wondering if someone could help me with a formula. I need to write a count if formula

Count is Type is Action and Status is not Completed, Decided or Closed. I know how to do on one criteria but how do I add count if not status is not decided or closed.

=COUNTIFS(Type:Type, "Action Item", Status:Status, <>"Completed")


Best Answer

  • Lori Khoury
    Lori Khoury ✭✭✭✭✭
    edited 09/21/22 Answer ✓

    HI SmartLew - I had to make one minor change but it worked!!! I just had to move the comma after completed.

    =COUNTIFS(Type:Type, "Action Item", Status:Status, AND(@cell <> "Completed", @cell <> "Decided", @cell <> "Closed"))

    THANK YOU!!!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!