Counting rows with a checkbox

Jeff_ARC ✭✭
edited 03/05/24 in Formulas and Functions

Hi I am trying to count the number of records that meet a certain criteria and has checked checkbox.

The formula I am trying is:

=COUNTIFS({Evaluation}, "1", {Resources}, CONTAINS("Scenario 2", @cell))

{Evaluation} is a column that uses check boxes

{Resources} is a column that uses dropdown selections

I want to count the number of times the evaluation checkbox is checked and Resources contains the phrase "Scenario 2".

If I separate each of the statements I get the appropriate information but when I am trying to use COUNTIFS with more than one range and criteria I am getting the error message ##Incorrect Argument Set



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!