Organize the returned value JOIN + COLLECT (?)

Hi guys, could you help me with a case? 

I don't know if it's possible, but is there any possibility of organizing the values returned to the cell in such a way that, starting with a symbol, the rest is organized right below, as in the next paragraph of the cell ? 

I'm saying this because with the combination of JOIN + COLLECT I managed to return all the values, but I wouldn't like them to be in an extensive way in the cell but in an organized way, one below the other. 

Thank you!


  • KPH
    KPH ✭✭✭✭✭✭

    If you are trying to join the values from multiple cells into one cell and have each one start on a new line then you can use the line break character as the delimiter in your join function. CHAR(10) is a line break.

    Your JOIN COLLECT might look like this:

    =JOIN(COLLECT(.........), CHAR(10))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!