How to link a smartsheet to roll up master?

Dan_P

I am using a SS template. The template only came with two project SS. (Project 1 and Project 2). I want to add more project SS and have them roll up into the master. I duplicated Project 1 and renamed. However, it is not rolling up into the master roll up sheet and therefore not displaying datum in the dashboard. Seems like a lot of individual formula linking to do, is that true?

Paul Newcome

It is either manual, API, or the premium add-on Control Center. My personal suggestion would be Control Center if you can get access to it.

Andrée Starå

https://community.smartsheet.com/discussion/122861/how-to-link-a-smartsheet-to-roll-up-master

Hi,

I hope you're well and safe!

There are a couple of ways to do that.

1 Premium App, Control Center
2 Smartsheet API
3 Cell-linking
4 Cross-sheet formulas

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Dan_P

Thx - I will investigate the options!

I see premiums are not part of the package we have here, nor do I have API experience. I most likely will look at option 3 & 4.

Andrée Starå

https://community.smartsheet.com/discussion/comment/439148#Comment_439148

Excellent!

Happy to help!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!