Hello. As I see, there are both Now and Today functions available in the automation rules context, while field formulas have only the latter, is that behavior intentional? I’d like to get the current date and time to be able to calculate hours passed since the DateTime value in the other field of …

Now() is not available in formula fields since it would imply that the formula would need to be recalculated every minute of the day, and this would overload the Fibery backend. How would you like to use the result of calculating hours passed? Perhaps you might find it more appropriate to use a sc…

[image] Chr1sG: Now() is not available in formula fields since it would imply that the formula would need to be recalculated every minute of the day, and this would overload the Fibery backend. That does make good sense, haven’t thought about it from the implementation point perspective. Fee…

[image] Uladzislau: introduce variables or some sort of automation-local formula fields I recently discovered the Google sheets formula keyword LET , which creates a “local variable” or alias just within a single formula.

"Now" function is missing

Get Help

Chr1sG August 8, 2026, 4:07pm 5

Topic		Replies	Views
Bug with Today not including time Bugs & Issues	2	263	December 15, 2023
A text string containing the current UTC timestamp in the format 'yyyy-MM-dd HH:mm:ss' generate a formula with errors (using Now()) Bugs & Issues	20	273	July 22, 2025
Allow "Now" in formulas, but calculate every minute to save costs Ideas & Features	8	177	August 8, 2026
Overdue task formula Get Help	15	639	August 11, 2023
Now() vs Today() Get Help	3	551	January 17, 2025

"Now" function is missing

Related topics