# Auto assign task to users

**URL:** <https://community.glideapps.com/t/auto-assign-task-to-users/6131>\
**Category:** Ask for Help\
**Created:** [March 30, 2020, 5:39am UTC](https://community.glideapps.com/t/auto-assign-task-to-users/6131 "2020-03-30T05:39:10Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\
**Post date:** [March 30, 2020, 5:39am UTC](https://community.glideapps.com/t/auto-assign-task-to-users/6131/1 "2020-03-30T05:39:10Z")

</div>

In the current app that I am building, this person has requested that incoming tasks in the queue be assigned to users. I know this isnt done automatically with glide but I would love any feedback or ideas on how I can accomplish this.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 30, 2020, 10:40am UTC](https://community.glideapps.com/t/auto-assign-task-to-users/6131/2 "2020-03-30T10:40:38Z")

</div>

First, you’ll have to answer the questions, “how/in what circumstances are these tasks currently being assigned manually?”

---

<div class="post-metadata">

**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\
**Post date:** [March 30, 2020, 1:26pm UTC](https://community.glideapps.com/t/auto-assign-task-to-users/6131/3 "2020-03-30T13:26:27Z")

</div>

The condition is to assign the task to the person who has not been assigned a task for the longest amount of time. So if I was assigned a task an hour ago but your last assignment was 3 hrs ago, you would get the next task.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 30, 2020, 1:47pm UTC](https://community.glideapps.com/t/auto-assign-task-to-users/6131/4 "2020-03-30T13:47:42Z")

</div>

This is doable. I imagine there being a sheet of all users with column that displays the date of the most recently assigned task from the log. In the form sheet, there would be rollup column that displays the oldest data and a lookup column of the user info that will be passed to the log when a new entry has been submitted. This should then update the values on the user sheet and thus change the rollup/lookup values.

---

<div class="post-metadata">

**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\
**Post date:** [March 30, 2020, 1:59pm UTC](https://community.glideapps.com/t/auto-assign-task-to-users/6131/5 "2020-03-30T13:59:58Z")

</div>

This helped me think of some variations of how to set this up. Thank you.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 18, 2024, 10:21am UTC](https://community.glideapps.com/t/auto-assign-task-to-users/6131/6 "2024-02-18T10:21:49Z")

</div>