Bradhickswa✭✭

I second this idea. I have various projects that I use Smartsheet to help manage and being able to color coordinate the sheets would be extremely helpful in distinguishing the projects from one another.

I second this idea!

Hi @Genevieve P. Thank you for the clarification! Cheers, Brad

Hi @Darren Mullen, Thank you for your response! Could you help me with how I would set up the formula? I tried doing it a number of ways with no positive result. The latest method was : =COUNTIFS({AB Shipping Status}, "In Transit", DESCENDANTS({WW02 Cross-Site} {AB Build Stage}), "POM to IHA")

@Paul Newcome Thank you, that's helpful!

@Leibel Shuchat I forgot to close my first statement! Silly me. Thanks!

Hi, I think you're looking for a COUNTIFS formula such as: =COUNTIFS({Sheet Reference}, "Yellow", {Sheet Reference}, "Green", {Sheet Reference}, "Red"). Hopefully that helps! Cheers, Brad

@Mike Wilday That is what I was afraid of. Thanks for your input!

@Paul Newcome I know of that capability, however, if I wanted to change the "set condition" part, it erases the rest of the cloned rule and I'd have to re-enter it manually again. I was wondering if there was a way to be able to change the set condition and keep the rest of the rule without deleting it.

The conditional formatting rule is that when 'Heading' column (main colored row in the grid view) is "title of the heading", then apply [task bar color] to the entire row. I checked my heading column, and all the rows match with the "title" they fall under, so there's no issue there. But as you can see in the Gantt view,…