Formula for specific status options not working
The current formula below is just returning a "0" when it should show a count of "3" according to the data
Purpose: Trying to show total number of "In Progress FPI" Status that filters only on "Critical" AND "High" Priority
Formula:
=COUNTIFS(Status:Status, "In Progress FPI", Priority:Priority, "Critical", Priority:Priority, "High")
Data snapshot:
Thanks for any guidance you can provide!
Answers
-
I think you forgot to bracket your columns your referencing. Does this work?
=COUNTIFS([Status:Status], "In Progress FPI", [Priority:Priority], "Critical", [Priority:Priority[, "High")
-
=COUNTIFS(Status:Status, "In Process FPI", Priority:Priority, OR(@cell = "High", @cell = "Critical"))
-
I was able to get this to work using this formula
=COUNTIF(Status:Status, "In Progress FPI") + COUNTIFS(Priority:Priority, "High", Status:Status, "Critical")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!