Editing Formula

Aseel Hawi

Hi there,

I have this formula in the Schedule Heath column (picture of sheet listed below). Currently, the default value for cells in the Schedule Health is Red. I want to change its gigantic formula so if the End date is blank, the schedule health stays blank too (instead of red). Appreciate your suggestions. Thank you!

Paul Newcome

Try starting the formula out like so...

=IF([End Date]@row <> "", IF(Summary@row = 0, ...................................

Paul Newcome

Try starting the formula out like so...

=IF([End Date]@row <> "", IF(Summary@row = 0, ...................................

Aseel Hawi

Worked!