Countifs with multiple criteria in the same cell

Options

How do I countifs, if the Risk is open, status is yellow and affects group C, D, E and F. I have the below formula but do not know how to add groups D, E and F

=COUNTIFS({FPR Risks Range 1}, "Open", {FPR Risks Range 2}, "YELLOW", {Group}, CONTAINS("D", @cell))...



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!