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.


  • Kimberly Loveless
    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.
    Tabitha W. ✭✭✭✭

    Your assumption is correct but it is still returning unparseable.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!