Change Gantt Color Automatically for Sheet and Report
Hello @Genevieve P.!
Overall, I'm attempting to create a report that shows multiple different projects. In that report, I will be able to see each projects' gantt bars. I'd like to color code the gantt bars to represent different phases in the projects in order to see what phase each project is in during a certain time period. This will show some projects are in creative development at the same time others are in Studio Production for instance.
- Is it possible for the gantt bar in a project to change color automatically based on the phase of the project?
- If so, I assume it's possible to pull those project sheets into a report to show the gantt bars and whatever else criteria I'd like to show in the report.
- Or is there better way to show the gantt bars in a different kind of report or dashboard view?
Thanks for any help and please ask me to clarify anything!
Some backup
- I probably went down the wrong path, but this screenshot shows that I created a column that automatically shows the phase as a color bar based on the date of the task in the project sheet. (Image 1 in attachments)
- I also looked at conditional formatting, but couldn't see an option to change the gantt bar or calendar in case that worked. (Image 2 in attachments)
Answers
-
The "Task Bar" is what determines the color of the Gantt / Calendar color in Conditional Formatting.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hmmmm…Thanks @Paul Newcome ,
That doesn't seem to change the gantt bar color
-
Shall I assume the gantt bar color cannot change?
-
Parent rows will not change. It is on the task level (child rows).
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Ahhh…Thanks @Paul Newcome
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives