Countifs formula for checkbox column has suddenly stopped working

Hello All,

My Countifs formula that counted when a box was checked in one of the columns has stopped working, giving me an invalid value error. I'm not sure if it was a recent update or what, but it has suddenly stopped working.

The Countif formula checks if the value in the checkbox column is checked:

=COUNTIFS([H1]:[H1], =[H1]@row, [Completed?]:[Completed?], =1)

The formula for the checkbox column is:

=IF(ISBLANK([Part Qty]@row), "", IF([QTY Finished Parts]@row >= [Part Qty]@row, 1, 0))

Some of the boxes are checked and some are not so I know this once is working.

Has anyone else experienced this issue?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!