Bring back result based on condition

Hi all,

Hoping I can get some help with a formula. I have a date column that I want to bring back a "health result" depending on the 'finish' date. For example if the finish date is past today's date then it would be red and there would be different thresholds for each date range. Is this possible? The "health result" is a column that shows color coded red, yellow, green or blue dot"

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!