IF formula for timestamp

Copper Contributor

JaneDoe2205_0-1709901172108.png

 

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. 

 

5 Replies

@JaneDoe2205 

Do B8, B9 etc. contain formulas?

If so, what do they look like?

Yes, the formulas are:
=IF(G8<>"", IF(B8="",NOW(), B8),"")
=IF(G9<>"", IF(B9="",NOW(), B9),"")

@JaneDoe2205 

Did you enable Iterative Calculation in File > Options > Formulas? That is required for these formulas to work.

HansVogelaar_0-1710000795628.png

Yes, I did. @HansVogelaar 

 

 

@JaneDoe2205 

I have attached a small sample workbook. What do you see if you enter or edit a value in column G?