Question for the group: Task Assignment Logic Help (FIFO Method

[babuam]

Hi everyone, I need help assigning tasks to staff based on category and task count using FIFO logic.

I have two sheets:

• Task Sheet: Contains Task ID, Received Date, and Category (A, B, C).
• Staff Sheet: Lists Staff Name, their Category, and the number of tasks they should be assigned.

📌 Example: If Staff1 is in Category A and has 5 tasks to be assigned, I need to allocate the earliest 5 tasks from Category A to Staff1 (FIFO method based on Received Date).

💬 How can I automate this assignment in Alteryx so each staff gets the correct number of tasks from their category, assigned in FIFO order?

[AncientPandaman]

generate each task capabilities to sort and join back to the task list.

[babuam]

I am not able to open the workflow. getting error message"Tool ID 1 is not the document"

[babuam]

Hi Community, 

Is there any solution for this idea. please update here

[Qiu · Accepted solution]

@babuam 
I expanded the tasks for each staff and join with task list based on order of Staff name.
I think we may need a priority for assignment for staff within same category in actual situation.

[babuam · Accepted solution]

@Qiu @Thank you for sharing the workflow.