Allow automation to populate cells with formulas.

Album

For some reason the devs have blocked using =formula() and they populate cells with '=formula() when you try to use the features in conjunction. This makes your formulas inert and is quite frustrating. This seems like such a easy way to increase efficiency in the program and should be implemented immediately. Thanks for coming to my Ted talk.

Adrian Mandile CHESS

It would be great if in the Automation Actions section, we couldCalculate a Value. This new feature could be achieved with an option under the existing 'Change a Value' action or in a separate action that would allow the user to enter a formula to calculate the value. In this way we could then paste that calculated value into the nominated column. This could be especially useful for Service Level Agreements that require responses to a request within a pre-set number of days, or by the end of the next week/month/quarter, based on an input start date.

SteyJ

As the name suggest, formulas in automation -- specifically forchange cell value.

This would be incredibly powerful, as it would reduce the number of helper columns needed for tasks such as checking for blank cells, and filling them with a formula if data doesn't exist. Not only would it provide great variability, but it would essentially allow text columns to become column formulas without the restrictions a column formula has.

I use a helper column with the new EAP TIME function to generate time created (in military time) for new activity events, and having a cell which can take user input and also automatically fill if blank for functions like this, would begame changing!

=SUBSTITUTE(IF([Time:]@row = "", TIME(MID(Created@row, 9, 9), 1), RIGHT("0000" + [Time:]@row, 4)), ":", "")