Multi-Row where row number changes

Question

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

PersonTaskA1B2C3D4E5F6 7 8 9 10 11 12 13 14

After

PersonTaskA1B2C3D4E5F6A7B8C9D10E11F12A13B14

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.

Norhusain · Answer

@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!

ccanterman · Answer

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

* List of Tasks in the one Text input (I put 17 tasks)
* Record ID Tool to number every task
* List of People in the other Text input
* Count Records for the number of people listed
* Append the number of people (6 in the sample)
* 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
* Join with the list of People, after throwing on a Record ID* 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

* 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

New Workflow1.yxmd