RAID Metrics


I'm trying to figure out how to build a formula using the COUNTIFS function that will count the number of ACTION items in our raid log but only if those items don't have one of our multiple closed status's. ONLY Active items if you will.

Current Formula: =COUNTIFS({RAID Type}, "Action") - this returns the correct count of action items but it includes Action items that are also closed. We have multiple closed status's and I don't want those included in the count.

Example Raid Types - Action, Risk, Issue, Decision, Question

Example Closed Status - Closed - Decision, Closed - Resolved

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!