Visual Gantt with Milestones Embedded

I'm trying to add a dynamic visual Milestone gantt on a Dashboard which lists %progress. This should be dynamic so that it displays real-time updates from the detail schedule that i'm pulling the Milestones from. Any suggestions on what tools are available.

Find more posts tagged with

Publish

Reports

Services

Dashboards

Project Management

Comments

Chris McKay

Hi Gladys,

I'll need a bit more info about what you're trying to achieve, but you can easily create a Smartsheet report that pulls milestones out of a project plan, displays a gantt and will update based on information in the detailed schedule.

Gladys Liley

Here's a visual for reference.

I am currently using a report change this to only display the timeline with milestones & progress. Is that possible?

Chris McKay

Hi Gladys,

Yes, you can create a milestone only report based on dynamic data from a project plan. However, you will not be able to pretty up the Gantt in the same way you have above, but something like the below images is possible.

I've added a symbol column to the left and asked it to look at 0 duration tasks and set the symbol to the diamond shape (advanced), then used conditional formatting to make it easier to distinguish milestones from tasks in the plan. I set the parent task milestone symbol to the green circle (easy) so I could include it in the report.I also used a dependency column to link the tasks together, so changing the date/duration will also change the dependent tasks.

For the report, simply choose the columns you'd like to display making sure to include Start Date and End Date, sort the report on the Start Date and finally set the What? criteria in the Report Builder to Milestone is Easy or is Advanced.

This will only pull out the parent row and milestones. Because it is linked to the plan, any changes to dates, durations, % complete etc. in the plan will be reflected in the report (and Gantt) automatically.

You could always export the report to Excel periodically and then plot the data there (as there are more formatting options) but then you'll lose the automation.

cchukwurah

I am still new to Smartsheet, and this sounds overly complicated. I am trying to build an executive dashboard where some of the tasks on my sheet will be listed as "milestones" on the dashboard. What is the easiest and most effective way to accomplish this?

Andrée Starå

Hi,

I answered in your other post, and I added the link here for others searching.

https://community.smartsheet.com/discussion/risk-flag-1#comment-166321

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…