Formula that will return multiple values in multi-select dropdown column

Ami Veltrie

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", "")))))))

Adam Murphy

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

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", "")))))))

Ami Veltrie

@Adam Murphy That works! Thank you Adam!! 🤩