Capture column data

Lucinda Bugbee

I am working on a construction plan set revision tracker where we are trying to capture dates for different revisions. There are 5 different revision types, and I have created a helper column to join the three items I want to capture. The problem is once I change the Revision drop down type, my information gets wiped out and I want it to be permanent. How can I do this?

Any suggestions?

ChristianFinke

Hey @Lucinda Bugbee

For keeping your revision data locked in first set up an automation to copy the info into a "record" column whenever a revision is selected. Then use a backup sheet to store each revision’s details so it stays put even when you change the dropdown.

Hope this helps! Let me know if you want a hand setting it up.