COUNTIF Formula Error in Sheet Summary
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))
Best 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.
Answers
-
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 - yes! That solved it. Didn't realize the space issue in the column. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!