Automating RYG if a date is too far past another

I have two columns "Date 1" and "Date 2", I want to have a formula for the status column using the RYG Status balls that will:

- Green if Date 2 is less or equal to 10 days past Date 1

- Red if Date 2 is more than 10 days past Date 1 

Please help


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!