Link a column from one sheet to another sheet.

JonBeaumont ✭✭
edited 03/31/23 in Formulas and Functions

I have a detailed sheet which I input a wide range of information useful for my usecase, but I want to make a summary sheet that only shows certain columns to a 3rd party so they can just see the information that they need.

I need new rows of information to automatically link to the summary sheet when new entries are made.

How come I can't just use the "=" followed by the cell I want then make that a column formula?

Seems complicated to just make a column copy into another sheet?

Any help would be helpful.

Many thanks,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!