Forum Discussion
CindyCHU
Nov 21, 2021Copper Contributor
Assigned job tickets to multiple people automatically
I have a main excel spreadsheet everyday for job tickets that operation teams completed on yesterday. I have 5 members who are auditing the jobs tickets, they working on 5 separate excel files. Eve...
Yea_So
Nov 21, 2021Bronze Contributor
first what are the categories of job tickets, next based on previous historical information how long does each person spend to get the particular job ticket category take, next who's good at which category, gathering all these information you can use in your formula logic to forecast which category job ticket to assign. In other words you rank each person on each job ticket category so you'll know which preferred job ticket you want to assign to each person based on their rank on how fast they can work on whichever category they're good at.