Multiple checkboxes in one cell  Formula for True (Part 2)
This is a follow question  reposting for visibility. While my original question was answered, I'm now having trouble with the formula. This formula seems to be working, however I am expecting it to return symbols. Instead, it is only returning the "text". Anyone have an idea why...? The column type is set to Symbols and restricted to symbol values, but is still showing text. Here is my formula:
=IF(COUNTM(Question@row) = 3, "yes", IF(COUNTM(Question@row) = 0, "no", IF(COUNTM(Question@row) > 0, "hold")))
Here is what I'm seeing
Best Answer

Hi @Shawn Church,
The answers need to capitalized.
Tyr this.
=IF(COUNTM(Question@row) = 3, "Yes", IF(COUNTM(Question@row) = 0, "No", IF(COUNTM(Question@row) > 0, "Hold")))
Hope this helps,
Dave
Answers

Hi @Shawn Church,
The answers need to capitalized.
Tyr this.
=IF(COUNTM(Question@row) = 3, "Yes", IF(COUNTM(Question@row) = 0, "No", IF(COUNTM(Question@row) > 0, "Hold")))
Hope this helps,
Dave

Yep  that's it! I used lower case because that is how it is represented in the column type description. Thanks for your help.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!