Automate Harvey ball color based on multiple variables
I'm not sure if what I want to do is feasible or not so please let me know if I'm going off the deep end. I would like to have a Harvey ball change color based on several criteria/variables to show likelihood the task will, or won't be, completed on time.
Has anyone made a formula that will show a red Harvey ball if the task is through, lets say, 75% of the duration and % complete is less than %50 (or something along those lines)? Then criteria for yellow and green?
Is it possible to include a variable of whether or not the task was started on time?
If anyone has already done something along these lines I would love to see what you have rather than reinvent the wheel.
Help Article Resources
Check out the Formula Handbook template!