Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Feature Request: JOIN() carriage return separator
I would like to JOIN() to allow the carriage return as a separator.
This would allow me to transpose the data.
JOIN([Column1]23:[Column12]23,"\n") would take the row and give me a cell with the contents transposed vertically.
JOIN([Column1]1:[Column1]22," ") would take the column and give me a cell with the contents transposed horizontally.
Integration to tools like Evernote or Slack would allow the notes to be visually easier to read and comprehend.