Formula that will return multiple values in multi-select dropdown column
![Ami Veltrie](https://us.v-cdn.net/6031209/uploads/userpics/8P0VG5OTWNRU/nHI3K0J42GX6A.jpg)
What is the trick to get the returned value to display as multiple values and not all one concatenated value?
=IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), ISBLANK([Telecom Team]@row), ISBLANK([Waste Team]@row)), "Utility", IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), NOT(ISBLANK([Telecom Team]@row)), ISBLANK([Waste Team]@row)), "Telecom;Utility", IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), NOT(ISBLANK([Telecom Team]@row)), NOT(ISBLANK([Waste Team]@row))), "Telecom;Utility;Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), ISBLANK([Telecom Team]@row), NOT(ISBLANK([Waste Team]@row))), "Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), NOT(ISBLANK([Telecom Team]@row)), NOT(ISBLANK([Waste Team]@row)), "Telecom;Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), NOT(ISBLANK([Telecom Team]@row)), ISBLANK([Waste Team]@row)), "Telecom", "")))))))
Best Answer
-
Replace the colons with CHAR(10) to create a line break, like this:
=IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), ISBLANK([Telecom Team]@row), ISBLANK([Waste Team]@row)), "Utility", IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), NOT(ISBLANK([Telecom Team]@row)), ISBLANK([Waste Team]@row)), "Telecom" + CHAR(10) + "Utility", IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), NOT(ISBLANK([Telecom Team]@row)), NOT(ISBLANK([Waste Team]@row))), "Telecom" + CHAR(10) + "Utility" + CHAR(10) + "Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), ISBLANK([Telecom Team]@row), NOT(ISBLANK([Waste Team]@row))), "Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), NOT(ISBLANK([Telecom Team]@row)), NOT(ISBLANK([Waste Team]@row)), "Telecom" + CHAR(10) + "Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), NOT(ISBLANK([Telecom Team]@row)), ISBLANK([Waste Team]@row)), "Telecom", "")))))))
Answers
-
Replace the colons with CHAR(10) to create a line break, like this:
=IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), ISBLANK([Telecom Team]@row), ISBLANK([Waste Team]@row)), "Utility", IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), NOT(ISBLANK([Telecom Team]@row)), ISBLANK([Waste Team]@row)), "Telecom" + CHAR(10) + "Utility", IF(AND(NOT(ISBLANK([Utility Team (Vertical)]@row)), NOT(ISBLANK([Telecom Team]@row)), NOT(ISBLANK([Waste Team]@row))), "Telecom" + CHAR(10) + "Utility" + CHAR(10) + "Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), ISBLANK([Telecom Team]@row), NOT(ISBLANK([Waste Team]@row))), "Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), NOT(ISBLANK([Telecom Team]@row)), NOT(ISBLANK([Waste Team]@row)), "Telecom" + CHAR(10) + "Waste", IF(AND(ISBLANK([Utility Team (Vertical)]@row), NOT(ISBLANK([Telecom Team]@row)), ISBLANK([Waste Team]@row)), "Telecom", "")))))))
-
@Adam Murphy That works! Thank you Adam!! 🤩
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!