Count open RAID items based off of dropdown menu
Options
Allison H
✭✭✭
I'm trying to get a count of open RAID items. We have the following statuses in the status dropdown: New, In Progress, Backlog, Requires Validation, and Complete.
What is wrong with this formula?:
=COUNTIFS([Type (RAAIDD)]:[Type (RAAIDD)], "Risk", Status:Status, OR(@cell = "New", @cell = "In Progress", @cell = "Requires Validation"))
Answers
-
I don't see anything wrong with the formula or the output. Based on the data in the screenshot, you only have one row that fits all of your criteria, more specifically the [Type (RAAIDD)] column having the text of "Risk".
-
Thanks Paul!
-
Happy to help! 👍️
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!