If/then formula to return a personalised value when multiple choices are selected ?
Our team has a sheet for our projects in which we have a multi-select column where we can select our contact name when we are assigned a project (column name is "Assigned to").
We have a very simple helper column that simply copies the information with the formula ="Assigned to"@row, so that we can view our projects in Card view by each team member (otherwise, it seems Card view does not support viewing by Contacts).
That being said, we have some projects that are assigned to multiple team members. To avoid cluttering the Card view columns with many columns that would include various combinations of our names, I'd like to create a formula for my helper column where, if multiple contact names are selected, then it would return a value of "Multiple collaborators", but if just one contact name is selected, it would return the value of that contact name.
Is this possible ?
Best Answer
-
You would use the COUNTM function.
=IF(COUNTM([Assigned To]@row) = 1, [Assigned To]@row, "Multiple Collaborators")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You would use the COUNTM function.
=IF(COUNTM([Assigned To]@row) = 1, [Assigned To]@row, "Multiple Collaborators")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That worked perfectly... thank you so much !
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 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
- 296 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!