Countif Formula in Sheet Summary not giving results


Just wanted to check with the community if there was any change to the criterion selection under the "COUNTIF" function.

I have a column formula for a checkbox column in a Smatsheet that flags if I get a result and the sheet summary calculates if the box is checked using "COUNTIF". I was seeing the results in the past in the sheet summary but now I see "# NO MATCH" in the same.

I know I am using the correct formula and I have been using Smartsheets for more than 6+ years. Is it something that was changed where one cannot summarize the column formula in Sheet Summary?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!