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.
Instead of using the Multi-Row Tool, I used Append
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
@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!