When using status columns to indicate some thing like “Pass”/“Fail” as subitems, we can generate a summary that shows (for example 3 pass and 1 fail) as a bar that is 3/4 green and 1/4 red.
My issue I have cases where there is at least one blank status in every column, This means I might have 3/4 green and 1/4 gray on one side and 1/4 green and 3/4 gray on the other, despite the actual values being 100% green.
I’m hoping to find a way to ignore the blank statuses when summarizing subitems on the parent item in a way that lets us keep using the status fields.
Thanks