Color Coding In Progress Tasks within a Specific Time Period in Gantt Chart
Is there a way to color code tasks in a gantt chart that occur during a specific time period? For example, I would like all tasks that are in progress during the months of May, June and July to show as red. I see that I can set conditional formatting to fill the cell background of tasks with specific start and complete dates, but this does not pull the tasks that are in progress. Thank you
Answers
-
Hi Alyjon14,
The colour of the task bar (as opposed to the cell background) is set using the little dropdown under Task Bar in the conditional formatting menu.
You can most likely create the rule you need directly in conditional formatting, but I often find it is more flexible to create an extra column check box called In Progress, and make the rule simple (If "In Progress" then apply ....). Then you can put a more complex formula into the "In progress" column, such as =AND([Start Date]<=July,[End Date]<=May).
This helps if you want to do things that are not directly supported in the conditional formatting rules, for instance highlighting tasks that have a due date in the next 6 working days, or on a Thursday, etc.
I hope this helps.
Regards,
Andrew
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives