IF, AND Formula for multiple parameters

06/24/20
Answered - Pending Review

Hello,

How do I create a formula for this scenario? I want the RYG Ball on the task level to automatically change colors when the dates on:

Finish is less than TODAY= Green

Finish is TODAY= Yellow

Finish is Greater than TODAY= RED


But I also want the RYG ball to turn green if the status has been marked complete, no matter what the finish date is?


Attached are the columns I am using:



Answers

Sign In or Register to comment.