Sign in to submit new ideas and vote
Get Started

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.

11 votes

Idea Submitted · Last Updated


  • 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)), ":", "")


    Jacob Stey

  • bkw1962
    bkw1962 ✭✭✭

    And the hits just keep on coming….Smartsheet still comes up short in so many ways. No real answers and even ghosting paying enterprise customers on critically needed functionality - for YEARS in some cases. Classic. The kids who built this mess should have stayed in their mommy's basement.

  • kcollins
    kcollins ✭✭✭

    Yes this would be such a huge win especially when it comes to hierarchies.