Formula to use?
I want to create a new column that combines (5) of the columns on my sheet.
This new column would be on the same sheet as the (5) columns.
Column A thru E
I want it to read like the below:
Column A  Column B Column C  Column D Column E
What is the best formula/ way to do this?
Thanks!
Answers

Hi @Lisa H.
=[Column A]@row + "  " + [Column B]@row + " " + [Column C]@row + "  " + [Column D]@row + " " + [Column E]@row
Does this help? Let me know.Sincerely,
Jacob Stey

Nope  that gives me an 'unparseable' error. But making sure I am doing it right  you do use the name of the column for each one in [brackets] right? Thx!
EDIT I just got it to work  I forgot a space where one needed to be at =) Thx!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 358 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!