Master Roll Up that Auto references a new sheet created from a template


Hello SS Community,

I am creating a master roll up sheet that counts how many "at risk" tasks a team member has across several projects. We have a Project template that each job gets created from.

My wish is to have the master roll up automatically reference the "health" and "assigned to" columns each time a new project is created.

Is there a way to achieve this? I tried creating the reference and then turning the sheet I referenced into a template but it wouldn't carry over.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!