Cross-Sheet Project Status Rollup (Dashboard?)

Long time user, first time trying to do something cross-sheet.

Lets say I have a folder called "Projects" and it contains all "Project Sheet" type sheets. Outside of the folder I'd like to have a sheet or a dashboard that dynamically looks at the sheets inside the folder, list out the sheet names with total % complete.

Any advice on where to get started? Is that a dashboard?

Find more posts tagged with

Project Management

Comments

Sasan

Mcnejef,

A Report would be the right product to compile information from multiple sheets (see Report help). Then use a Dashboard Report widget to showcase your rollup.

Hope this helps.

Sasan

Sign in to join the conversation!

Quick Links

Trending discussions

Automation Across Multiple Task Checklists in a Workspace
I have multiple task checklists to monitor so I need one weekly report that will show all the past due tasks from every checklist under the one Workspace. Currently, I'm adding the Automation to each checklist. Is it possible to just add it to the Workspace itself and run to capture from all the checklists?
New to SmartSheet - 2 questions on functionality
1: When using a SS form, is there a way to deny a duplicate entry based on an employee name or number? 2. Is there a way to somehow link from SS to Outlook to create calendar invites based on a date field in the SS? Thank you! Kat Gavigan
How to Display Clickable Links on a Dashboard That Update from a Metric Sheet
I need to add clickable links on a Smartsheet Dashboard that automatically update based on changes made in a Metric Sheet. I tried using a Metric widget, but the links appear only as plain text and are not clickable. Is there a way to have hyperlinks on the Dashboard that stay clickable and get updated whenever the Metric…