countifs formula works in cell but not in sheet summary

Hi, All

I have this countifs formula - '=COUNTIFS([Point SysName]:[Point SysName], <>"", [Cable Roughed In?]:[Cable Roughed In?], 1)‌'.

When I put in in a cell, it works. But when I put in a sheet summary field, it comes up with an error message of '#UNPARSEABLE'.

In the attached photo, the number '2' is the result I am after for the two ticked boxes. You can see the error message in the sheet summary field on the right.

Any pointer will be much appreciated!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!