Mar 08 2024 04:40 AM
I am using the above formula for time stamps to automatically be input if data is entered in the specified cell. However, whenever I enter data in the g7 column, the time and date stamp changes for each item in the b column in unison. Not just changing the time and date for b7. I do not understand why the formula is not working.
Mar 08 2024 05:00 AM
Mar 09 2024 08:02 AM
Mar 09 2024 08:13 AM
Did you enable Iterative Calculation in File > Options > Formulas? That is required for these formulas to work.
Mar 09 2024 12:13 PM
I have attached a small sample workbook. What do you see if you enter or edit a value in column G?