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
- 62.9K Get Help
- 379 Global Discussions
- 209 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!