Conditional Formatting applied to Gantt View?

natemcwhorterHelix · 06/15/22

Is there a way to apply the conditional color formatting to the Gantt View bar itself?

Antonio de Sousa · 06/16/22

Hi Nate,

In the conditional formatting dialog you have the option of choosing the color of the gantt task bar.

You can find more info here:

Conditional Formatting | Smartsheet Learning Center

Regards,

Antonio

natemcwhorterHelix · 06/16/22

I should of been more specific, is there any way to apply the conditional formatting to the Gantt bar without setting it for the 'entire row', it seems that the Task Bar option disappears when I select only a few cells that I want the formatting to apply to.

Andrée Starå · 06/17/22

Hi @natemcwhorterHelix

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P. · 06/20/22

https://community.smartsheet.com/discussion/comment/333099#Comment_333099

Hi @natemcwhorterHelix

You're correct, you'll need to select "Entire Row" for the Task Bar to appear because it is not limited to specific columns. If you have other formatting rules based on the same conditions that you want to apply to only certain columns, you'll want to create two rules with the same conditions but different outputs.

Here's more information around Changing the Color of Task Bars.

Cheers,

Genevieve

Conditional Formatting applied to Gantt View?

Answers

Categories