How to manage many identical Smartsheets?


I have been asked to develop a group of 70+ project trackers for departments.


  • Task, Sub-Task
  • Category
  • Percent Complete (roll-up)
  • Start Date
  • End Date
  • Status

Each of the 70+ unit project trackers will dashboard.

Each of the 70+ trackers will contain ~50 tasks.

The columns are to be identical across sheets, but may change. Formulas may change. Dashboards may change.

Is there any way to specify global/shared columns across sheets? Do you recommend another way to approach this project?

Best Answer