Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Showing Milestones in Sights

Options
ysuzuki
ysuzuki
edited 12/09/19 in Archived 2017 Posts

I use a Sight as a dashboard, so I created a report to pick up only entire schedule for each project. i.e. I have 5 "bars" in the report, represents 5 projects.  And I want to show milestones with each bar. Can I do it? If so, how?

Each bar is cell-linking so I can go each sheet (project) if I click and see milestones. But I want to see them at the dashboard level because this is the info the management sees. 

By the way, I want to show milestones on the bar, not separate row (i.e. I have 3 milestones, and it doesn't look good if I show 4 rows = 1 bar schedule + 3 rows of milestones!).

Thanks for your ideas! 

 

Comments

  • Shaine Greenwood
    Options

    Hello,

    There currently isn't a way to display milestones in reports or Sights, they'll appear as 1 day tasks.

    When you have a moment, submit an enhancement request for this functionality directly to our Product team using the product enhancement request form under Quick links on the right of the community site.

  • steven.reed14881
    steven.reed14881 ✭✭✭✭✭
    Options

    Shaine,

    Not sure on your response here. You are definitely able to designate tasks as Milestones by manually setting their duration to '0.' This is recognized by the Gantt view as a Milestone (evidenced by the Milestone icon). You can then include Milestones on reports by using Duration equal to 0 in the Report Builder. I didn't extend that on to a Sight, but I am pretty sure that would work too.

    Now I have no idea on how to possibly get multiple Milestones to appear on a single row for each of these five projects. But at least Smartsheet will allow you to report on those Milestones.

     

    Steve

  • ysuzuki
    Options

    Shaine, I submitted an improvement request. Isn't it a popular request? If you think about dashboard usecase, showing milestones in separate row doesn't make sense. 

  • Shaine Greenwood
    Options

    I've seen the request before but I'm not certain on the popularity of the request.

    Reports right now don't have a lot of insight in to what types of data they're displaying. They might know how to bring in a column titled "duration" but they have more limited logic compared to a sheet in the many ways that duration affects a task's display of the Gantt chart.

    Our Product team is working on many improvements, and I know we're wanting to revamp the Reporting functionality down the road. I don't have an ETA for when we'd see this feature make it into Smartsheet, though.

  • callanson60051
    Options

    Re last requirement

    "By the way, I want to show milestones on the bar, not separate row (i.e. I have 3 milestones, and it doesn't look good if I show 4 rows = 1 bar schedule + 3 rows of milestones!)."

    Can I please add my voice to the list.  When presenting to stakeholders Milestones should be ON the bar.  This is the logical association as it is a milestone for that piece of work.  Also looks neater.

    Thanks

    Cam

     

     

  • Hugo Martinwall
    Options

    I also want to add my voice to the list. I currently have this problem and it would make sense to see the milestones on a report IN the dashboard

    Kind Regards

    Hugo

This discussion has been closed.