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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!