If statement based on date paired with Smartsheet Symbol

I have a sheet that lists due dates in one column, and I was wondering if there is a way to use an If/then statement within the symbol column to indicate the following:

If the due date is within last 12 months, the symbol is green

If the due date is between last 12-18 months, the symbol is yellow

If the due date is longer than last 18 months, the symbol is red

Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!