We are looking to distribute New Deals to our team through a weighted Round Robin. We have New Deals coming in through PipeDrive when a contract is signed. From there we've sent them to a New Client Pipeline. We would like to distribute these new Deals to our team members individual pipelines through a weighted "round robin". There are currently 12 team members. With these 12 team members we would like the leads to be distributed in a way that certain people get more leads than others. For example: Team member 1 & 2 get 17% of the leads that come through Team 3 & 4 get 10%, etc.
We are looking to use a solution similar to https://community.zapier.com/discussion/133/easy-edit-round-robins-using-a-google-sheet#latest using the spreadsheet to manage the positions of the team. It seems that we may be able to do this by adding Team members multiple times, so they show up in the round robin more frequently than say, Team member 12 that only gets 3% of the leads.
My ultimate question, is this even possible? It seems like it is in theory, but is there a way to do it without a Zap with 70 different steps?
Any advice or suggestions are most helpful!
Best answer by DanversView original
@Lacey! You'll always need a few different steps to do this, but there is a way that uses fewer than in the Google Sheets Workaround. You can use the Formatter app as a lookup table, which should save you a step.
You can find out more about using the Storage and Formatter apps to create a Round Robin in this help guide.
Let me know if you have any questions!