Column Value to Multiselect

Nicole D
Nicole D ✭✭✭✭
edited 09/12/23 in Formulas and Functions

Hello - I'm using a multiselect formula but it's populating a "0" in front of the multiselect if the multiselect is zero or one value.

My formula:

=IF(CONTAINS("Yes", [Air Travel]@row), "Air/Flight" + CHAR(10)) + IF(CONTAINS("Yes", [Rental Car]@row), "Car" + CHAR(10)) + IF(CONTAINS("Yes", Hotel@row), "Hotel" + CHAR(10))

How can I have it remove the 0?

I tried using the in-sheet automation to select values but it keeps removing previously selected values, even though it's set to not replace values:

It removed "car"

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!