Autofill a column with what populates in other range of columns
Hey Smartsheet Wizards,
How do I auto-populate a cell in a column with the value from another range of columns in the same row?
E.g. I would like Row 1, Column A to auto-populate with the value that appears in Row 1, Column B - Z. Only one Column from Columns B - Z will populate based on what's entered in a Form Field. However, I do not want to scroll over/through Columns B-Z just to find which column is filled, then copy and past that cell to Column A. I'd rather have Column A autofill with whichever single cell is populated in Columns B - Z of the same Row.
Best Answer
-
See if this meets your need,
Assuming only one of the columns from B-Z is populate:
=JOIN([Column B]@row:[Column Z]@row, "")
Assuming multiple columns from B-Z are populated (values are comma separated. You will not be able to know which column exactly is populated unless you follow the count of commas to match the columns)
=JOIN([Column B]@row:[Column Z]@row, ", ")
Answers
-
See if this meets your need,
Assuming only one of the columns from B-Z is populate:
=JOIN([Column B]@row:[Column Z]@row, "")
Assuming multiple columns from B-Z are populated (values are comma separated. You will not be able to know which column exactly is populated unless you follow the count of commas to match the columns)
=JOIN([Column B]@row:[Column Z]@row, ", ")
-
Perfect, thank you! It works. Just one follow up question. The rows are added every time a form is submitted. Will I have to add the formula every time a new row is added?
-
I tested my question (what I should have done to begin with), and it works. The formula stays in that column as new entries (rows) get added.
Thanks again for you help!
-
I hope you're well and safe!
You could also convert it to a Column Formula, and then you won't need to worry about it.
More info.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!