Fill Down...Diagonal

[JMart2135]

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

[Maskell_Rascal · Accepted 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

[JMart2135]

Thanks @Maskell_Rascal ! I knew I was overthinking it. Definitely been a long week. Thanks again!