Adding to an Existing Conditional Formula: Date Field

Kal-El

Good Day All:

 

I am trying to add to my existing formula if the date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee, and Delivery date) then green

All help greatly appreciated, Thanks!

Existing Formula: =IF([Approved by Committee]2 = 1, "Green", IF([Changes Required]2 = 1, "Yellow", IF([In Review]2 = 1, "Yellow", IF(AND([Approved by Committee]2 = 0, [Changes Required]2 = 0, [In Review]2 = 0), "Red"))))

Published http://publish.smartsheet.com/79d1c2945b3b46c18bb3099455f2b6b2

SmSulli

I think you would use the ISBLANK function.  Not sure which Date column you wanted.  So you'll have to change that in the formula below.

=IF(ISBLANK([Date]2), "Yellow", IF([Approved by Committee]2 = 1, "Green", IF([Changes Required]2 = 1, "Yellow", IF([In Review]2 = 1, "Yellow", IF(AND([Approved by Committee]2 = 0, [Changes Required]2 = 0, [In Review]2 = 0), "Red"))))