For now i have 2 spots that have a time stamp when text is entered/changed C19 changes text C20 is date stamp, same with C30 and C31 getting date stamp.
C19 pulls its cell value from another place and updates (to the same value) every time the document is opened so i don't want that to change the date stamp in C20. I only want it to give a date stamp when it changes text or number values to something different than it was previously. E.g. from being black to HT098 or from HT098 to HT099 but if it stays and refreshes to HT099 from then on, don't change time stamp.
Note: that value in C19 is pulled from the beginning part of the file name so it will always stay the same typically, but that is why it is updated every-time the doc opens, because its triggered to fill that cell with that info with a formula.
C19 pulls its cell value from another place and updates (to the same value) every time the document is opened so i don't want that to change the date stamp in C20. I only want it to give a date stamp when it changes text or number values to something different than it was previously. E.g. from being black to HT098 or from HT098 to HT099 but if it stays and refreshes to HT099 from then on, don't change time stamp.
Note: that value in C19 is pulled from the beginning part of the file name so it will always stay the same typically, but that is why it is updated every-time the doc opens, because its triggered to fill that cell with that info with a formula.