I have a spreadsheet with 3 columns; A
roduct, B
rice, C:date where from time to time I update the prices and I type in the date the price changed in the last column.
I want to automate the date stamping. However, I only want the date to be updated when the value in column B (price) is amended.
I'd like the existing records in column C to persist until there is a change in column B. In other words, I want to keep the existing values and only change the dates I have when the price in column B is changed, and otherwise leave the existing dates alone.
I've found many ways to add a timestamp but none that will keep existing values unchanged until a condition is met. The date will need to persist and not change each day I reopen the spreadsheet.


I want to automate the date stamping. However, I only want the date to be updated when the value in column B (price) is amended.
I'd like the existing records in column C to persist until there is a change in column B. In other words, I want to keep the existing values and only change the dates I have when the price in column B is changed, and otherwise leave the existing dates alone.
I've found many ways to add a timestamp but none that will keep existing values unchanged until a condition is met. The date will need to persist and not change each day I reopen the spreadsheet.