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
-
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!
Answers
-
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!
-
@Paul Newcome Yes! That did it. Thank you!
-
Happy to help. 👍️
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!