Date Change Tracking

Topic Labels: Formulas
127 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello, community! I need to create a formula (or find some other way) to keep track of changes to individual cells in "column A" via a second column that auto-populates with first entries in column A but does not change if column A changes after that. 

So for example:  

Column A = Project Start Date

Where a user manually enters the date they begin a project.

Column B = Original Project Start Date

Where it auto-populates with all existing dates in Column A + new dates added to empty cells

But does not update itself when a user manually changes the date in Column A after that. 

The goal is to be able to allow users to adjust or move out their start dates as needed but also keep a record of what the original date was without adding any other manual steps. I really hope this makes sense! TYIA for any help or ideas!


0 Replies 0