How to replace data from diferent row

[BautistaC888]

Hello,
I need to replace the 1900-01-01 in the Date field for the data on the Real_Date field on the row above.
Thank you.

[DannyS · Accepted solution]

Hi @BautistaC888 ,

If I'm understanding your question correctly, you're looking to replace the cells that have value '1900-01-01' in the Date* column with the cells in the Real_date column that come one record above. If that is this case, you can do this in one step using the Multi Row Formula tool in the Preparation category by creating a simple conditional expression:

I've attached a workflow to demonstrate.

Let me know if this helps!