Return Multiple Words In a Cell

Tabitha W.

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.

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.