Automatically / Random assign

Emi
Emi ✭✭
edited 07/29/22 in Smartsheet Basics

Hi All,

I want to know if there is a function for automatically assign to a person to random task every single day in the morning.

For example, I have 5 tasks everyday and would like to randomly assign to a person each day in the responsible column.

Thank you

Answers

  • Hi @Emi

    You can set up a workflow to assign contacts in a contact column, see: Assign People in an Automated Workflow

    However this workflow will need set conditions to work off of to identify who should go in each cell. There currently isn't a way to randomize that, we would need to program conditions in (does that make sense?)

    If you can give us more information in regards to your task list and how many users you have, perhaps there's a formula we can build to help? For example, we could use a formula to show if the row number is Odd or Even, then if you had 2 users you could assign one to all odd rows and one to all even rows.

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now