Change symbol based on date
Good morning Everyone,
I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which...
Green appears if the last run date is within 30 days
Yellow appears if last run is within 31-60 days
Red appears if last run is 61 or more days
Can anyone help me write this formula? Thank in advance.
Help Article Resources
Check out the Formula Handbook template!