Forum Discussion
JaneDoe2205
Mar 08, 2024Copper Contributor
IF formula for timestamp
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 chan...
HansVogelaar
Mar 08, 2024MVP
- JaneDoe2205Mar 09, 2024Copper ContributorYes, the formulas are:
=IF(G8<>"", IF(B8="",NOW(), B8),"")
=IF(G9<>"", IF(B9="",NOW(), B9),"")- HansVogelaarMar 09, 2024MVP
Did you enable Iterative Calculation in File > Options > Formulas? That is required for these formulas to work.
- JaneDoe2205Mar 09, 2024Copper Contributor