Community

1

Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. 

So for example, let's say "Phase 1" of a project is the parent, we would like an

1

This is my current formula and it is working fine.

=IF([New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6)

I want to add that if New/Existing is BLANK - to not return anything.  Not sure how I can modify this.