I have a spreadsheet that I use to track inbound calls. I already have the formula that determines whether or not I'm understaff or over-staffed for that day simply by dividing =D25/D5 cells. If it it's under 100% then technically I'm understaffed for that day, if it's over 100% then I'm over-staffed for that day. This is noted on the far right of my screen shot labeled "Complete to Inbound %."
With that said, what I'm trying to pull now, is a headway percentage for the day. For example: How much gain did we make based off of the total of "Total New Tickets" vs. "Total Completed Tickets" received and complete? You'll see my example in the screenshot attached. (located to the far right) and is labled "Actual Gain %". Wonder if someone might be able to help me figure out the formula or workaround to this?
Your help is greatly appreciated!