Hi everyone! I am running into an issue in my sheet, report, and dashboard. In the main sheet, I have several line items that associate with a gantt chart for project management. Three of them are highlighted / shaded in blue with no conditional formatting that correlates to that setting. Anyone know why this is occurring?…
Looking for some help on Crosstab style reporting from Shartsheet Gantt data. I have a Gantt project like the below ... How can I produce a report like this one I mocked up in an Excel Pivot table after cutting and pasting and "massaging" the Gantt data? ... Do I need the premium Pivot App (which we don't have) or is there…
This discussion has been merged.
Would be extremely helpful for high level reporting to be able to have a parent row which is showing the overall Gantt bar be able to display a child row as a milestone marker along that bar. Our project portfolio would benefit from being able to show the go-live milestone that is occurring during the project execution…
Hello - I used a simple project plan template and the Gantt chart is not showing anything. I would like for it to show at least the budget / cost, and if possible, I would also like it to show the Task. How can I do that? When I create a new sheet (without selecting a template, the Gantt chart shows the Task (or whatever…
It would be great to have user definable fiscal quarters in the new Timeline view. Also, as I am creating this discussion, there isn't a tag for Timeline View yet 😁
Hello! I need to create a report to visualize resource utilization per project over time, similar to this: https://community.smartsheet.com/discussion/76598/how-do-you-track-parallel-projects-and-show-overlapping-resources Some important context: I do not have access to resource management or resource settings. All of my…
Request: Allow users with editor or viewer access to change the timescale when printing a gantt view to a PDF, and for that setting to be persistent for that user. Background and our use case: I was not aware, but apparently editors cannot change timescale of the gantt when printing to PDF. They can change the display…
I have a Report that references timelines in a Sheet, and the colors do not match between the two. Why is this and how do I fix it? At first it looked like the report bar colors were importing the colors of children tasks, but even after updating those it won't adjust on the report.