How to avoid using Now() to reduce the calculation time of a Doc to check the hour?

4

I think Coda might still see that a calculation was made with that variable and still trigger re-calculation of other formulas using it. The best bet to guard against this sort of dependency is to rely on a value that is written to a cell instead of one that reacts to a formula.

Here is an example you can try:

4 Likes