Jun 02 2019 08:17 PM
Jun 02 2019 10:40 PM
Hi @abundas
I see a slight change required in the first part of your formula:
It should say =IF($J2="", TODAY(), and not =IF($J2, "",
=IF($J2="",TODAY(),IF($J2<=$I2,"On-Track",IF($J2<=$I2 + 30,"Behind","Off-Track")))
Hope that helps?
Cheers
Damien
Jun 03 2019 05:55 PM