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!