Duplicating a Status column to generate a Previous Status

Renea Davis-Leathers

I am using weekly status updates via a form to collect "Next Steps" "Risks and Needs" and "Status". The "Modified" column is autogenerated.

I have been asked to add a "Previous Status" column to the output.

I want to copy the value from "Status" in Row1 and display it in Row 2 "Previous Status". Then repeat for all following rows.

Can I do this in a report? Can I do this in a formula within the Sheet?

Ryan Sides

Hi @Renea Davis-Leathers

Create an Auto Generated Number column named "Row".

Then in your Previous Status Column, add this formula:

=INDEX(Status:Status, MATCH(Row@row - 1, Row:Row, 0))

This will grab the status of the previous row.

Ryan Sides

Hi @Renea Davis-Leathers

Create an Auto Generated Number column named "Row".

Then in your Previous Status Column, add this formula:

=INDEX(Status:Status, MATCH(Row@row - 1, Row:Row, 0))

This will grab the status of the previous row.

Renea Davis-Leathers

And indeed it does! THANK YOU.