I have a spreadsheet that a requirement is to Date/Timestamp (C2) a cell based on when the proceeding Cell (B2) is updated to the stored item “NMC”. The formula that I am using is as follows:
However, this formula works…too well… not only does that ROW timestamps, but all the other Rows with the same record changes as well. Or if I select any of the other two items (PMC or FMC) the timestamp will change immediately for any record with “NMC”.
I am a loss to how to fix this timestamp for the one record, not the others unless they are physically changed.
see the attached file