Forum Discussion
How to insert timestamp (IF NOW functions)
Hello all! Im having trouble with inserting timestamp, as is: =IF(A2<>"",IF(B2<>"",B2,NOW()),"") This formula should put timestamp in B2 if any entry in A2 is given, but I got error in result...
Both formulas return timestamp, here is result for second one
if only you enable iterative calculations in settings
otherwise it'll be circular reference error. But you shall be quite careful with this setting to avoid side effect, e.g. if another circular reference eventually appears in workbook you may miss it and have wrong result in calculations.