Sheet /Column sharing

Options

I have 5 sheets. The first 8 columns on each of the sheets are the same. The balance of the columns of each sheet are different. Is there a way to have the first 8 column interactive regardless of which sheet you are in. So whether you make a change in sheet 1 or 3 (within those 8 column) all 5 sheets in that cell are changed.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!