Formula with OR Statement

edited 12/09/19 in Formulas and Functions

Good evening:


I am trying to add an OR to the formula below:


=COUNTIFS(Priority:Priority, ="P1", Status:Status, ="Potential")

Potential or Active


Thanks for your help in advance!



  • Hi


    Why don't you use countif and count the factors separately?

    Just an idea...

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    =COUNTIFS(Priority:Priority, ="P1", Status:Status, OR(@cell = "Potential", @cell = "Active"))


    You use the OR function in the Criteria section and use @cell references to make them logical statements for the OR.


    The same can be done with AND statements which is especially useful when looking at date ranges.

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!