Hello,
I have a table like the one below that I want to fill down but diagonally (From "New Value" down 1 row, left 1 column to "Prev Value")- grouped by my task number. After this i will be filtering out the rows where Prev Value=New Value. I am using this as a change log for this date field. I know how to fill down normally, but not sure how to go about this diagonally. Any ideas, other methods are welcome.
Task | Prev Value | New Value | Last Modified |
0001 | 2/7/2020 | 3/11/2020 15:07 | |
0001 | WANT "2/7/2020" HERE | 3/7/2020 | 3/15/2020 15:07 |
Thank you!
Jesse
Solved! Go to Solution.
Hey @JMart2135
You can accomplish this with the Multi-Row Formula tool. You even have the option to Group By specific fields, so it will limit the fill down within a grouping like say an account number.
Anyways, here is how you'd set it up.
I've also attached a sample workflow for you to try out.
Thanks!
Phil
Thanks @Maskell_Rascal ! I knew I was overthinking it. Definitely been a long week. Thanks again!