Autofill a column with what populates in other range of columns

Options

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

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!