Column Value to Multiselect

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"

Find more posts tagged with

Accepted answers

Paul Newcome

Give this a try:

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

All comments

Paul Newcome

Give this a try:

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

Nicole D

Thank you, @Paul Newcome!

Paul Newcome

Happy to help. 👍️

I tried to bold the changes, but they don't stand out very well. Basically we just told each IF statement to output a blank if false. Leaving that portion blank usually outputs a blank but when "adding" IF statements together to create a string, I have noticed that Smartsheet tries to literally add the outputs together if there is nothing there. Since there was nothing, it was "zero plus.....".

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.