Automatically Make Job Assignments based on turn and region

DrewSwick
DrewSwick ✭✭
edited 03/08/23 in Smartsheet Basics

Hello,

I am looking to automatically assign one of two employees based on their region and which one of them had the prior assignment. So basically, if it is in their region, they take turns receiving the assignment. I have set up a contact column, "Employee" (Contact column), "Row ID" (system column), and "Region" (dropdown list). Any guidance would be appreciated!

Best Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @DrewSwick

    Ah my apologies, it does make a difference that you don't have the same criteria for your employees.

    In this instance, I would set up multiple "Assign Next" columns - one for each region:


    =IF(Region@row = "Canada", INDEX(COLLECT(Employee:Employee, Region:Region, Region@row, COUNT:COUNT, MIN(COLLECT(COUNT:COUNT, Region:Region, Region@row))), 1))


    Then you would need to set up multiple workflows, each to check the correct columns:

    Does that make sense / will that work for you?

    If not, it would be helpful to see a screen capture of your sheet set-up (but block out sensitive data) and an explanation of how many total employees you will want to auto-assign.

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • DrewSwick
    DrewSwick ✭✭
    Answer ✓

    This got it done for me. Thank you so much!

Answers