This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow calculation that has many calculation dependencies between columns. Because of this, I need to run a portion of the workflow row by row instead of column by column.
For example, column D row 2 is calculated based on values in Row 1 of columns A, B, and C. However, Column A, row 2 needs to perform a check on column D row 2 in order to get its value. Column A and D depend on each other and need to be calculated in conjunction with each other, but there are also dependencies between row 1 and row 2, so I can't simply use a formula tool.
I'm using multi-row formulas to perform this calculation, but the workflow is giving me an incorrect result because it's performing calculations for column A, then B, then C, then D, so the dependencies aren't being reflected properly.
Transposing the data didn't work, so I'm currently trying to do this with an iterative batch macro. I haven't been able to set up the macro so it will accept input in the middle of the workflow.
Can someone give me an example of a macro which runs a section of the workflow row by row? I appreciate the help!