"IF" formla and Red/Yellow/Green


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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!