What the best way to manage 8,000 Projects in Smartsheet

I am new to Smartsheet and not sure how or if the program can help...I have project where I am rolling out a new program to 8,000+ locations and looking for way to leverage Smartsheet to manage. I know there is a 5K row so not sure how to proceed. Most threads talk about pulling rows out once complete but my project is a 60 day program start to finish. We have tried SharePoint but Smartsheet is more user friendly and was hoping it could work to manage the rollout.

Any guidance is greatly appreciated.

Find more posts tagged with

Construction

Reports

Real Estate

Project Management

Comments

Andrée Starå

Hi,

The best setup greatly depends on your specific needs and how your projects are configured. One way would be to split the projects in some way (area, pm, product) and then get an overview with a report.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

C. Glass

Andrée's suggestion of segmenting the projects into smaller groups is a good one.

Another possible path is to also think about how roll-up sheets and dashboards could help you manage the overall. I'm unsure what your needs are in terms of managing this set of rollouts and the level of detail you require, but it could be handy.

We're using this with a detailed project sheet for each implementation that covers the specific steps, task assignments, etc. Those then roll up to a summary sheet that brings each group of projects into focus. We also use a metrics sheet to feed a dashboard.

Good luck!

JScot

Thank you! I am interested in the utilizing the system to do roll-ups and dashboards so I can have one executive summary/reporting on the status. Are there any resources to explain how this is done?

Andrée Starå

Hi,

Happy to help!

The solution center is a great starting point, and you can come a long way with the different template sets.

Would that work for you?

Best,

Andrée Starå - Workflow Consultant @ Get Done

jamiet18

Can you point me in the right direction for this? I don't believe it was ever shared.

Thanks!

Jamie

Andrée Starå

Hi Jamie,

Of course. Here are some great starting points.

Templates: Create Your Own or Use One from the Solution Center

Solution Jump-start: Project Tracking and Rollup

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.