Duplicating a Status column to generate a Previous Status

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?

Find more posts tagged with

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.