Master Roll-Up for multiple project sheets
I am reviewing the Construction and Facilities Management template set provided by Smartsheet. I only have a Team account for now.
The template comes with 2 sheets for Projects. In the Master Roll-Up sheet, you can see the formulas used to pull the info from the 2 Project sheets.
Question: Do I have to manually update the formulas in the Master Roll-Up sheet everytime I add or remove a sheet for a project, or should the Master Roll-Up sheet update its formulas automatically?
My primary interest in this template is to see how to roll-up multiple project sheets. If we have 50 active projects, each with its own sheet, I need the master roll-up capability... but I don't want to edit the formulas in the master roll-up each time a project sheet is added or archived.