I have a formula that should check if the time it’s before or after a certain hour of the day and according to the result pass a different value to an automatic message for an email body. It’s not a critical feature as I can quickly bypass it with a general greetings formula, but this poses me a problem if anyone have figured out how to check the hour without using the Now () functions that checks the time every second and it’s quite system resource intensive. My doc it’s growing very fast and the formula it’s been calculated on every single row of a big table.
Can i write anywhere in the doc the formula and than check against it? Does it reduces the calculation time? Does anyone else have found a workaround for that or could suggest a syntax?