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.

Find more posts tagged with

Accepted answers

Sameer Karkhanis

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, ", ")

All comments

Sameer Karkhanis

See if this meets your need,

Assuming only one of the columns from B-Z is populate:

=JOIN([Column B]@row:[Column Z]@row, "")

=JOIN([Column B]@row:[Column Z]@row, ", ")

OxfordCommaUser

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?

OxfordCommaUser

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!

Andrée Starå

Hi @OxfordCommaUser

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.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.