Formula to test for Date + If Date Is Within One Year

SEBERCAW
SEBERCAW ✭✭
edited 10/11/23 in Formulas and Functions

I know that =IF(DATE@row <> "", "Green", "Red") will tell be if there is a Date.

I need to add one more condition. That the date is also within the last year.

Can someone please help me?

I want the column to be Red if either condition fails and Green if both conditions are met.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!