It doesn’t seem to be possible in the app to get a Time in a formula with hours in it. Some historical notes mention a Now() function, but that doesn’t seem to exist anymore.
One other note when creating a column it would be nice to have better messaging about needing a column name
It’s not a bug. Now() is not available in formula fields because if it were, it would imply that the formula would be recalculating every second, which would simply overload the formula service.
It is however possible to use Now() in an automation formula, since that would only be calculated when the automation is triggered.
oh interesting. that makes sense. Appreciate it. I have been moving over from airtable and it’s interesting to see the tradeoffs fibery makes that seem to support a less expensive infrastructure, which I appreciate.