How to manage many identical Smartsheets?
I have been asked to develop a group of 70+ project trackers for departments.
- Task, Sub-Task
- Percent Complete (roll-up)
- Start Date
- End Date
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?