RYG function based on Status and Start Date

robzas

I am able to have the Status (RYG) show up based on Status (which is tied to percent completed). I am trying to add the function so if the Start Date is in the future the status defaults to Green.

This is what I'm using for the RYG now:

=IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green")))

I end up running into issues when I add "OR" and try to make status Green if Start Date is in the future.

David Tutwiler

You could start with the Start Date at the beginning. So something like:

=IF([Start Date]@row > TODAY(), "Green", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green"))))

David Tutwiler

You could start with the Start Date at the beginning. So something like:

=IF([Start Date]@row > TODAY(), "Green", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green"))))

robzas

Thank you - that worked

David Tutwiler

Great! Glad it's working.