I am creating a Project Management tool that calculates Planned start/due dates based on its dependencies. They way the tool is currently designed, I am looking to find a way that the tool is able to utilize the result from the macro to recalculate dynamically (based on the amount of rows) so for each time it runs, there will be new populated fields.
The problem is that if allow the flow to only run the macro batch one time( It will only bring the values based out of the original populated values and so everything else below still remains blank - not desired)
I am uploading the file for clear understanding. But the desired state it would be something like this:
Pre-Iteration (Note that I calculated the first row prior to executing the Macro)
ID | Task | Duration | Dependency | Planned Start Date | Planned Due date |
1 | Task 1 | 2 | 09/14/2020 | 09/16/2020 | |
2 | Task 2 | 2 | 1 | ||
3 | Task 3 | 2 | 2 |
Iteration 1
ID | Task | Duration | Dependency | Planned Start Date | Planned Due date |
1 | Task 1 | 2 | 09/14/2020 | 09/16/2020 | |
2 | Task 2 | 2 | 1 | 09/16/2020 | |
3 | Task 3 | 2 | 2 |
Iteration 2
ID | Task | Duration | Dependency | Planned Start Date | Planned Due date |
1 | Task 1 | 2 | 09/14/2020 | 09/16/2020 | |
2 | Task 2 | 2 | 1 | 09/16/2020 | 09/17/2020 |
3 | Task 3 | 2 | 2 | 09/17/2020 |
Iteration 3
ID | Task | Duration | Dependency | Planned Start Date | Planned Due date |
1 | Task 1 | 2 | 09/14/2020 | 09/16/2020 | |
2 | Task 2 | 2 | 1 | 09/16/2020 | 09/17/2020 |
3 | Task 3 | 2 | 2 | 09/17/2020 | 09/19/2020 |
Solved! Go to Solution.
Hi @matcarvalho,
I think an iterative macro may work better than a batch macro. Each iteration joins the Dependency to the ID, then copies the Planned Due date from the ID (parent) to the Planned Start Date of the Dependency (child). I use variants of this type of macro to roll up trial balances from accounts to parent nodes.
Thank you so much! That is really helpful. I am going to do some research here, because even though I can see your model works, I still don't fully understand how iterative macro works.
Next Step: Study Iterative Macro.
Thank you! I really appreciate it.