How to create Harvey balls to show progress of work
Please I need help creating Harvey balls that will
show “Green” when work progress is FULL
show “Red” when work progress is NOT FULL and End Date is less than TODAY
show “Yellow” when work progress is less than FULL and NOT EMPTY
show “Gray” when work progress is EMPTY and End Date is BLANK
Would also like the Harvey balls to roll up in the summary rows.
Help Article Resources
Check out the Formula Handbook template!