Can you combine the criteria of formulas?

Hi, I'm looking to input a formula to a sheet which will count the number of "Open" residual risks that are also recognised as 16 and above.

I already have a column for the number of Residual Risks scored 16 and above and a separate column counting the total number of open risks on the entire sheet.

Is there a way to make it count only the "open" number of risks scored 16 and above, currently it is counting residual risks 16 and above but both open and closed.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!