Updating the Red or Green Status Column based on Dates from another column


I'm trying to create a formula that changes my status column to the red or green symbols.

I want to base it on my Renewal Date column.

I looked at some examples on the site, but wasn't able to get it to work on my sheet. I was trying to set up a formula around the following parameters..

If date is in the past turn status symbol Red.

If date is in the future, turn status symbol Green.

Thank you in advance for your help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!