RYG Status Formula Based on % Complete and Start Date
I'm a novice user of Smartsheet. I'm trying to add a formula based on % Complete and the Start Date. I'd like to automate the status based on the following parameters:
If % Complete is greater than .24 = Green
If % Complete is greater than 0.14 = Yellow
If % Complete is less than 0.14 = Red
If Start Date is in the future = blank
Help Article Resources
Check out the Formula Handbook template!