Blank Value for Schedule Health

Michaela Collins

Hello,

working with the formula below for schedule health:

=IF([% Complete]@row = 1, "Blue", IF(Status@row = "Cancelled", "Blue", IF(Status@row = "On Hold", "Yellow", IF(TODAY() > [End Date]@row, "Red", IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row < 0.5), "Yellow", "Green")))))

Would like to add: If [End Date]@row is blank, return a blank cell. but it isn't allowing me to use either of the following formulas. Any help as to what I am doing wrong?

=ISBLANK([End Date]@row, IF([% Complete]@row = 1, "Blue", IF(Status@row = "Cancelled", "Blue", IF(Status@row = "On Hold", "Yellow", IF(TODAY() > [End Date]@row, "Red", IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row < 0.5), "Yellow", "Green"))))), " ")

or

=IFERROR(=IF([% Complete]@row = 1, "Blue", IF(Status@row = "Cancelled", "Blue", IF(Status@row = "On Hold", "Yellow", IF(TODAY() > [End Date]@row, "Red", IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row < 0.5), "Yellow", "Green"))))), " ")

Paul Newcome

Try this:

=IF([End Date]@row <> "", IF([% Complete]@row = 1, "Blue", IF(Status@row = "Cancelled", "Blue", IF(Status@row = "On Hold", "Yellow", IF(TODAY() > [End Date]@row, "Red", IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row < 0.5), "Yellow", "Green"))))))

Paul Newcome

Try this:

=IF([End Date]@row <> "", IF([% Complete]@row = 1, "Blue", IF(Status@row = "Cancelled", "Blue", IF(Status@row = "On Hold", "Yellow", IF(TODAY() > [End Date]@row, "Red", IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row < 0.5), "Yellow", "Green"))))))

Michaela Collins

Thank you so much! That worked great!

Paul Newcome

Happy to help. 👍️