IF Planned Date is Still blank leave RGB Status Column Blank
Hi, If you could please assist with the formula below? The formula works perfect, except for when no date is entered in the Planned start date. Currently when no date is entered in the Planned start column the RGB ball stays "Red", and i would like it to show "".
=IF([Kick-Off Meeting Actual Finish]1 <> ""; "Green"; IF([Kick-Off Meeting Planned Start]1 < TODAY(); "Red"; ""))
Help Article Resources
Check out the Formula Handbook template!