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 100% = Yes
If % Complete is greater than 0= Hold
If % Complete is 0 = No
If Start Date is in the future = blank
Thanks in advance for any help!
Help Article Resources
Check out the Formula Handbook template!