How to automate RYGB balls based on due date and completion

I am trying to automate the "Status" column to display the following based on the "Original Action Due Date" column:

Coming due in greater than 60 days - Green

Coming due in 60 days - Yellow

Past due - Red

I am also trying to automate the "Status" column to return a blue color when the "Date Closed" column is populated with a date.

I appreciate any help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!