conditional formatting of taskbar in Gantt chart

dizzy_brain

I am new to Smartsheet and not sure where to find the relevant info. I have figured out how to conditionally format in grid view (e.g. if item selected in dropdown menu of some column is x, then color the task name column green, etc) but I would also like to make the taskbar for that row in Gantt chart also green. And so on. In conditional formatting, I am able to select to apply some format to various columns of the sheet, but how do I apply the same to the Gantt chart (the taskbar color)? Thanks.

BullandKhmer

Genevieve P.

Hi @dizzy_brain

To add to @BullandKhmer's image, the Task Bar option will only show up if you have the "where" in your rule set to Entire Row.

See: Apply Formatting Automatically with Conditional Formatting Rules

Cheers!

Genevieve

dizzy_brain

Thanks for that, I can now see it! (It is a bit obscure and not very intuitive though, that you have to select entire row only to NOT apply the formatting to entire row but to taskbar instead)