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.

Find more posts tagged with

Templates

Sheets

Solution Center

Project Management

Comments

Andrée Starå

Hi,

Yes, you would have to update the formulas. You could maybe use reports instead. Depending on your specific use case that could work, or there might be a better solution.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Pete Bennett

A teammate of mine gave me the idea (which again, should not be needed) of creating a band-aid using an automated workflow - such as telling the underlying Sheet to lock and then unlock a row, daily at say 3am. I am going to try this.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…