Sign in to submit new ideas and vote
Get Started

Allow automation to populate cells with formulas.

Album
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.

8
8 votes

Idea Submitted · Last Updated

Comments

  • Adrian Mandile CHESS
    Adrian Mandile CHESS ✭✭✭✭✭

    It would be great if in the Automation Actions section, we could Calculate 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
    SteyJ ✭✭✭✭✭✭
    edited 08/16/23

    As the name suggest, formulas in automation -- specifically for change 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 be game changing!

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

    Sincerely,

    Jacob Stey