Holding a calculation until specified date.

Shane Shelton

Hello, I would like to set up a row of cells to run a calculation at a specified date and time. If that is not tricky enough, I want that calculation to remain as is thereafter even though the data that the calculation uses would change frequently. Is there a way to prevent a cell from running a calculation until a specified date and keeping the result on future dates?

Andrée Starå

Hi Shane,

A possible workaround would be to use a third-party tool like Zapier or similar

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Shane Shelton

Thanks, Andrée. I do have a Zapier account. I will play around with it and let you know what I come up with. 

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

Paul Newcome

Depending on how often the sheet is activated (opened, updated, etc) which it sounds like it could be often, you could simply write in an IF function.

 

=IF(TODAY() >= DATE(yyyy,mm,dd), [formula you want to run], "")

 

You would simply set the DATE function as the first day you want the calculations to run, and it will continue running forever and ever.