Harvey Ball Formula Question

SBZ

I have the following formula and need to make sure it's accurate in terms of capturing the work completed. Basically, when 6 out of 7 subtasks are completed at 100%, the harvey ball is still showing an empty grey circle for the task above which stores the subtasks. However the row above the task which contain the 7 subtasks show a 75% harvey ball.

=IF(ISBLANK([% Complete]@row), "", IFERROR(IF([% Complete]@row = 1, "Full", IF([% Complete]@row > 0.74, "Three Quarter", IF([% Complete]@row > 0.49, "Half", IF([% Complete]@row > 0.24, "Quarter", "Empty")))), ""))

Paul Newcome

Are you able to provide some screenshots for context?