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

1 Reply

  • 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