I want Sheet 1 data in a column to show on Sheet 2 when added


I want to add projects listing the project name, location, and status in Sheet 1 and when they are added there, I want them to populate automatically on sheet 2 in the same project name, location, and status columns.

-- A report will not work because there is additional column data in sheet 1 and sheet 2.

-- I tried a number of different index function formulas but none were working for me. And if I drag the formula down in each column of Sheet 2, will it update the correct row #?

-- Work around with cell linking, but it's only allowing me to link up to 20 rows. I think this is an option, but there is a better one.

Help? @Paul Newcome

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!