Multiple checkboxes in one cell  Formula for True
I have a column asking three questions with the option to check one or all. Is there a formula to test if all checkboxes in one cell have been checked? I would like to apply the fomula to a symobol column where if all boxes are checked it will return a "true" value.
Best Answer

Hi @Shawn Church,
You can do this with the COUNTM function.
=IF(COUNTM[Question]@row =3, 1 ,0)
Substitute the 1 and 0 with your symbol preferences.
Answers

Hi @Shawn Church,
You can do this with the COUNTM function.
=IF(COUNTM[Question]@row =3, 1 ,0)
Substitute the 1 and 0 with your symbol preferences.

Thanks! That worked.

Follow up question....
The formula seems to work, however, it is only returning text values and not the symbol. Here is my formula:
=IF(COUNTM(Question@row) = 3, "yes", IF(COUNTM(Question@row) = 0, "no", IF(COUNTM(Question@row) > 0, "hold")))
What am I doing wrong?

It's very simple to fix: you need to capitalise the words (e.g. "yes" to "Yes") and the symbols should show up correctly.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!