Formula for late and overdue tasks
I'm new to Smartsheet and looking to replicate a formula I used to use in another software product. I would like to create a health indicator that will tell me the following:
- If task is 100% complete - Blue indicator
- If task % complete is GREATER than task % duration complete - Green indicator (e.g 50% work complete but only 20% duration passed)
- If task % complete is LESS than task % duration complete - Yellow indicator (e.g. 20% work complete and 50% duration passed)
- If task % complete is LESS thank 100% and today is GREATER than Finish date - Red indicator
The first and last are straight forward enough, but I'm struggling with the middle two since I'm not as familiar with the field names. Any help you could provide would be greatly appreciated.