Forum Discussion

kmarquez's avatar
kmarquez
Copper Contributor
Dec 20, 2023

Stop auto updating now function

Hello, I need to stop the now function to stop auto updating every time I open my spreadsheet. Does anyone have anything that can help me? This is my current formula: =IF(ISBLANK(A17)," ",NOW())  
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Dec 20, 2023

kmarquez 

  • Select File > Options > Formulas.
  • Tick the check box 'Enable iterative calculation'.
  • Click OK.
  • In the following, I'll assume that the formula is in cell D17.
  • Change the formula to

=IF(A17<>"",IF(D17<>"",D17,NOW()),"")

 

Resources