Allow 'Change Value' in Automations to add a functioning formula

SandraMS

Currently Change Value converts any formula added to text.

Remove the " ' " to allow functioning formula to be automatically added

exzavier

It would be a great adddition to add formula's to columns when a workflow is called.

This would be a great help when adding lines from forms etc....

Please advise if anyone has a work around for this.

Thank You

David

DKW

Please and thank you- I just discovered the cell automation feature. Very powerful as is but with formulas, it will make it incredible. Thank you.

cpearson25

In referencing back to the conversation below, which has been ongoing for several years, I would also love to have this ability! Not sure why there are restrictions on it right now, but it would be a huge time saver.

https://community.smartsheet.com/discussion/80120/change-cell-value-automation-can-i-add-a-formula-to-the-cell/p2

YiyunJ

If "add a formula" is not possible now, can you allow the "Change Value" feature to an existing column on the sheet? For example, use the Created Date column to automate another "Month" and "Year" column.

Dana Michael

Because currently there is no way to log a time upon approval, I am trying to think of other workarounds to log the time. One way was to use the automation to update the field using the TIME fomula, yet here I am, prevented by a single '…

kcollins

Yes this would be so helpful to our work - especially in reference to formulas that are almost a column formula but with a few exceptions.

DavidDumler

I'm putting in my vote to have this feature added too. This is a limitation that is inhibiting my automation of complex sheets and project plans.

Kevin Jensen

PLEASE add this functionality