Join/Collect Multiple Columns to One Cell WITH Column Name

I'm trying to combine data from multiple columns across a row into one cell in that row that I can zap to another program. I'd like for the information from each column to be preceded by the column name. (Example "Column Name: Column 1 Data, Column 2 Name: Column 2 Name: Column 2 Data, etc.)

I've figured out how to collect the data from each column and include a line break between each, but I'm stuck at how to insert the column names that correspond to the data. I have the Column Names in a helper row, row 1.

My working formula:

=JOIN((COLLECT(Program@row:[Time tracker ISBN]@row, Program@row:[Time tracker ISBN]@row, @cell <> "")), CHAR(10))

Is there a way to insert the Column Name (row 1) into the formula?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would have to write it out more long form.

    =IF([FIrst Column]@row <> "", "FIrst Column: " + [First Column]@row + CHAR(10)) + IF([Second Column]@row <> "", "Second Column: " + [Second Column]@row + CHAR(10)) + IF([Third Column]@row <> "", "Third Column: " + [Third Column]@row + CHAR(10)) + ..................................

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!