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.
Help Article Resources
Check out the Formula Handbook template!