COUNTIF Formula Error in Sheet Summary



Trying to use an existing formula in our sheet summary that is working for another column (dropdown list) in sheet summary. Not sure why it's not picking up the count for some columns and not others. The forumula's look the same and I've replace the column and cell names. Getting back 'unparseable' error. I've noticed that on the columns where the formula is working, the column is highlighted in blue. On the broken one it's not…

Thank you in advance for any guidance!

Formula that is Working: =COUNTIF(Channel:Channel, CONTAINS("Event", @cell))

Formula that is Not Working: =COUNTIF(Strategic Alignment:Strategic Alignment, CONTAINS("Baby", @cell))

Best Answer

  • Jgorsich
    Jgorsich ✭✭✭
    Answer ✓

    columns named with spaces or numbers have to be wrapped in brackets "[]", so try this:

     =COUNTIF([Strategic Alignment]:[Strategic Alignment], CONTAINS("Baby", @cell))

    that way Smartsheet knows the space is part of the name.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!