Need help with using a COUNTIFS with OR
Hi,
I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location.
Ticket Active Status for Location = Location <and> Status [Open <or> In Progress]
My Status column is using RYG balls, so "Red"=Open and "Yellow"=In Progress.
I keep getting errors returned no matter what I have tried.
Any help would be greatly appreciated!
Tags:
Best Answer
-
Try something along the lines of...
=COUNTIFS(Location:Location, "Specific Location", Status:Status, OR(@cell = "Red", @cell = "Yellow"))
Answers
-
Try something along the lines of...
=COUNTIFS(Location:Location, "Specific Location", Status:Status, OR(@cell = "Red", @cell = "Yellow"))
-
Paul,
Thanks so much for the help. The formula did the trick.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!