I have to monitor CSRs in a call center. 4 to 6 calls per CSR per month. We have a 72 hour waiting rule if the CSR fails 1 or more categories to allow time for coaching.
I want the formula to check the last time I monitor a call and if the score is less than 100, then it will take that date and add 72 hours.. This way I know what would be the next available date I can choose a call from.
The formula Im using works, but if a CSR score a 100 in more than one call... it does not function. Also we don't always score round 1 first and then round 2... sometimes we have to skip and do 1st, 3rd, 5th, 2nd.
Here I attach an example. Im using an complex IF formula, if there is a better way, let me know..
Bookmarks