How to generate a date from the end date of a previous row

[APAlteryx]

 I am trying to create a flow where when I have rows that have some same elements e.g., (Record ID, Project, Construction Type) and has two different records for [Door Install Date]  (1and 3), that the [Door Install Date] "1"  end date will take the start date of [Door Install Date] "3" and enter that into a new column called [New End Date].     So for the record 23, Project Green:  [Door Install Date] "1" has a [New End Date]  of "1/1/2025" which is the Start Date o Record 23, Project Green [Door Install Date ] "3".    For records where it is only one record, or the project is reflecting  [Door Install Date] = 3, (e.g., Record #27), the [New End Date] will just copy the existing [End Date]. 

Can someone help me to tackle this?  I was trying the summarize tool  but am drawing a blank now.  Than you in advance!

Record ID	Project	Construction Type	Door Install Date	Start	End	Difficulty	New End Date
23	Green	Door	1	11/1/2024	2/5/2025	Standard	1/1/2025
23	Green	Door	3	1/1/2025	5/5/2025	Standard	5/5/2025
25	Yellow	Door	1	6/6/2023	10/11/2023	Hard	11/1/2023
25	Yellow	Door	3	11/1/2023	1/5/2025	Hard	1/5/2025
27	Blue	Door	1	2/15/2022	9/1/2024	Hard	9/1/2024

[apathetichell · Accepted solution]

I'd use a multi-row formula.

new datatype (new end date)

values that don't exist sould be set to null()

group by Record ID

if [Row+1:Start]=null() then [End] else [Row+1:Start] endif

[AnnaMikhaylova]

Hi @APAlteryx,

You should be able to accomplish this by using multi-row formula tool:  

 

[APAlteryx]

Thank you both for this solution, this is exactly what I was looking for!