Multi-Row where row number changes

[NorhusainJr]

Hi Everyone,

I have built a workflow that automatically distributes tasks in the team. Problem is I have to manually change the Multi-Row formula depending on the number of people present each day.

Before Running the Workflow

Person	Task
A	1
B	2
C	3
D	4
E	5
F	6
	7
	8
	9
	10
	11
	12
	13
	14

After

Person	Task
A	1
B	2
C	3
D	4
E	5
F	6
A	7
B	8
C	9
D	10
E	11
F	12
A	13
B	14

MULTI-ROW Formula used: IIF(ISNULL([Person]),[Row-6:Person],[Person])

Issue:

- Today PERSON = 6

- Next Day PERSON = 4

Is there a workaround where I don't need to manually edit the MULTI-ROW Formula.

Appreciate all inputs you may have about this.

[Carolyn]

Instead of using the Multi-Row Tool, I used Append

1. List of Tasks in the one Text input (I put 17 tasks)
2. Record ID Tool to number every task
3. List of People in the other Text input
4. Count Records for the number of people listed
5. Append the number of people (6 in the sample)
6. Formula Tool to find the Mod between the Tasks' Record IDs and the number of people. This should accomplish what you're trying to do. It's also handy because if the list of people change, the Mod will auto-change based on the Count and just keep cycling around
7. Join with the list of People, after throwing on a Record ID
   1. Note - it assigns Person B with the first task, since Person A is at the end, instead of the beginning. If that's a problem then change the People Record ID to start at 1 and add an IF statement on the Mod to say "if Mod = 0, then [Count], else Mod" which will change the 0 to a 6 (for example). I was trying not to over complicate it
8. Sort to prove that it worked

 

Edit: Here's the workflow with 4 people listed in the Text Input box. Person C and Person E had the day off and aren't included in divvying up the Tasks

 

[NorhusainJr]

@Carolyn - thank you! I will try to integrate this approach on my template hopefully it works. Will update you after once it works. Appreciate it!