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.
Comments
-
Hi there, you can use IF statements intermingled with AND statements to make the formula you are looking for. But I don't have time to figure the duration percentage... you'll need to develop that...
=IF(AND([duration % column]1 < .75, [% complete]1 < .5), "Red", IF(And...
build it out that way. But you have to have either a formula or column calculating your duration to check the % of time.
-
Thanks for pointing me in the right direction!
-
Sure thing! Let me know if you encounter any issues or if you have any questions.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!