"IF" formla and Red/Yellow/Green

Dale Callaway

I am putting together a sheet that will be used as a template. There are 3 columns (Date Assigned and Date Due and Status). Status states Complete, Not Complete, and Not Applicable. There is another column that has the Red/Yellow/Green bubbles that should automatically update (red if late, yellow if within the date range, green if complete).

How would I configure the formula if the Status status "Not Complete" and is outside the date ranger (delinquent) and the bubble turns Red. Green if Complete, and Yellow if within the date range?

I know I've done this but it's been a few months and the formulas have been removed from my other sheets as they were no longer needed.

Paul Newcome

Try something like this...

=IF(Status@row = "Complete", "Green", IF(TODAY()> [Date Due]@row, "Red", IF(TODAY()> [Date Assigned]@row, "Yellow)))

Paul Newcome

Try something like this...

=IF(Status@row = "Complete", "Green", IF(TODAY()> [Date Due]@row, "Red", IF(TODAY()> [Date Assigned]@row, "Yellow)))

Dale Callaway

Thank you. I knew something like a nested IF function was the way to go.

Paul Newcome

Happy to help. 👍️