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
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
-
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.
-
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
-
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.
-
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.
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives