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.

Is it possible for summary bars on Gantt to be subject to conditional formatting?

Jef Forward
Jef Forward ✭✭✭✭✭
edited 12/09/19 in Archived 2015 Posts

 

Okay - My conditional formating on this sheet is set to change the color accross the entire row and bar.  If  status is checked, the gantt bar goes to grey, if not checked, it stays green.  The summary bars are not changing.  Is this possible?

 

Thanks

 

Jef

summary bar on gant chart.png

Comments

  • I think it is not possible the change the color of the summary bars. 

  • Travis
    Travis Employee

    Hi Jef, it is possible to change child row Gantt bars with conditional formatting but not parent row Gantt bars.

     

    You can use conditional formatting to change the background color of parent rows in the Gantt and grid. To do this, when setting up your rule, select "entire row" for the scope and select a background color to apply. 

     

     

  • Kurt
    Kurt ✭✭✭✭

    It would be very helpful to be able to change the color of milestones and especially summary tasks because Summary tasks and milestones are the tasks that are most commonly used in reports to show progress and status.  



    Here is an example:  I would like to change the colors of the Gantt bars in my Report, but Smartsheet doesn't let you set the bar color within a report, only the underlying sheet/project.  But, if the task from the underlying sheet/project is a summary task, then I can't change the color there either.  See the problem this presents???

This discussion has been closed.