COUNTIFS with 2 values in the same column
Options
tim.curtin
✭✭✭✭
Hello,
I need to count status values which reside in the same column that are related to a specific track. I think I need to add OR( in the formula but am not sure how that is formatted. My current formula is below.
=COUNTIFS({Status}, @cell = "Backlog", {Status}, @cell = "In Progress", {Track}, @cell = "Dashboard Reporting")
Answers
-
See below how to use the OR function:
=COUNTIFS({Status}, OR(@cell = "Backlog", @cell = "In Progress"), {Track}, @cell = "Dashboard Reporting")
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!