Count multiple values in a single cell
Hello. I'm very new to Smartsheet and a complete novice with functions. I can get by with bountiful resources in this community. I can't seem to find any other instance of the question I have about contact column conditional formatting. I hope it's possible.
Ultimately, I want to apply conditional formatting to a cell when there were multiple entries. I was planning on starting by using a checkbox column with the formula to return true if a cell in the row has more than 1 entry. This would allow me to keep the column small and the team alert to more than one "Contact" entered in the cell with the conditional format. Contact columns don't show 'bubble' entries like other multiple entry cells.
I've tried some basic if and countif formulas, but unsuccessfully. =IF([Requestor(s)]@row > 1, 1, 0) This returns true for all entries including those with only one value. Am I close, is it feasible?
Best Answer
-
Hey @Rootools
Smartsheet has a function that specifically counts entries in multi-select cells.
=COUNTM()
To put this in your checkbox column
=IF(COUNTM([Requestor(s)]@row)>1, 1)
This will check the box if greater than 1 and will do nothing, which leaves it unchecked, if false
Kelly
Answers
-
Hey @Rootools
Smartsheet has a function that specifically counts entries in multi-select cells.
=COUNTM()
To put this in your checkbox column
=IF(COUNTM([Requestor(s)]@row)>1, 1)
This will check the box if greater than 1 and will do nothing, which leaves it unchecked, if false
Kelly
-
Thank you very much for both the answer and link to the information I was seeking.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!