Return Multiple Words In a Cell

Hi Smartsheet community,

I am trying to return multiple words in a single cell. Is this possible as I can't figure out how to get my formula to work?

Right now it is only displaying one phrase, I tried to use Or then and with no luck (as shown below).

All help is appreciated :)

As you can see, I am trying to show all offices that have availability which will ultimately feed and reflect into my calendar and dashboard.

Find more posts tagged with

Accepted answers

All comments

Kimberly Loveless

You can use Join/Collect

=JOIN(COLLECT([Column 5]$3:[Column 15]$3, [Column 5]@row:[Column 15]@row,=0),",")

With this I am assuming the row where the room #s are listed is row 3, range from Office 113 - Office 206B is the entire range, and that you want them separated by a comma. Any of those can be tweaked if that is not the case

Tabitha W.

Your assumption is correct but it is still returning unparseable.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.