I have a spreadsheet with a list of all requests received from a customer daily, each request has a priority of high , medium or low depending on the category it falls into, so eg a customer who have 10 issues are considered low , a customer who has 20 problems is considred medium and a customer who requires 50 issues is considered HIGH priority.
All high priority customers will take 5 days to turnaround - all medium take 3 and all low take 2 days. I need to create a tracker on a seperate sheet in the same workbook showing how many requests are received daily , how many lows /mediums and highs are received and then how many are turned around . so basically after 2 days i need the tracer to automatically flag all lows which do not have a completed flag and also show all completed lows.
hope this makes sense - appreciate any helps out there - Thanks
All high priority customers will take 5 days to turnaround - all medium take 3 and all low take 2 days. I need to create a tracker on a seperate sheet in the same workbook showing how many requests are received daily , how many lows /mediums and highs are received and then how many are turned around . so basically after 2 days i need the tracer to automatically flag all lows which do not have a completed flag and also show all completed lows.
hope this makes sense - appreciate any helps out there - Thanks