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

Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…
Cannot move items
I want to move a sheet on my workspace to another folder but I am not getting the option to do so. I am the owner of the workspace, the sheet and the folder.