Countifs: Help with syntax in Countifs Formula with multiple conditions

Options

Hello All, I am trying to return a count when 2 conditions are present from a referenced smartsheet. This is the formula I created according to the guides I can find, but smartsheet says it is unparsable. Can someone let me know what the error is?

=COUNTIFS({Range 3}, "Current", {Range 2}, "Critical")

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!