Count open RAID items based off of dropdown menu


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"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!