task status based on expected % complete
I am trying to write a formula that will return red, yellow, green, or gray staus symbols based on the following criteria:
- Gray - If actual % complete = expected % complete
- Green - if actual % complete > expected % complete
- Yellow - if the actual % complete is within 10% below the expected % complete
- Red - if the actual % complete is more than 10% below the expected % complete
Where "expected % complete" is calculated as follows: =(TODAY() - Start@row) / (Finish@row - Start@row)
Would you be able to help me with the formula? Also please feel free to correct my assumptions if they overlap or are not inclusive.
Help Article Resources
Check out the Formula Handbook template!