COUNTIF Formula Error in Sheet Summary

Loni French

Hello,

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))

Jgorsich

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.

Jgorsich

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.

Loni French

@Jgorsich - yes! That solved it. Didn't realize the space issue in the column. Thank you!