Using formula in automation fields

Hello,
The automation fields don’t currently allow calculations in fields.
For example, I want to create an automation that pulls the date from a selected record and adds or subtracts a number of days from that. It would be a very useful feature to automate some project tasks without having to manually enter the dates. I’m giving an example with dates but automation would be largely enhanced if we could use formulas in fields.
Thank you.

3 Likes

Yes, this would be very helpful.

In the meantime, you can create the formula fields in your table, hide them so you don’t have to see them, and then refer to those formula fields in your automation.

1 Like

Hi @ScottWorld – I’m attempting to copy a value from a formula field into a new field and it’s not pulling a value.

The goal is to create master filters in a different table, for example, Day of the week. Is this not supported?

I’m not sure what you mean? Do you have a video or a screenshot of what you’re trying to do?

Figured it out! I needed to convert the field to text with CONCAT or &“”.