Countifs and check boxes.


Good Day,

I keep receiving unparseable/ errors for this formula. I've typed this 20 different ways. I'm very lost at this point.

=IFERROR(COUNTIFS({Oil Change Tracking Range 1}, [Zone:]@row, {Oil Change Tracking Range 2}, [Service Date:]@row, ({Oil Change Tracking Range 4}, = 1))"")

My end result is to check a box if these 3 things are present.

- if the {range 1} matches my [zone]@row and

-if {range 2} marches my [date]@row, and

-if {range 4} has a checkmark in the cell.

Sheet with the error and second sheet is my reference sheet.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!