Currently Change Value converts any formula added to text.
Remove the " ' " to allow functioning formula to be automatically added
Sign in to see the current vote count, add your own vote, or leave a comment.
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
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.
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
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.
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 '…
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.
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.
PLEASE add this functionality
Just following up on this thread. I too would love to have the function to an automation to add a formula to a cell based on something changing.
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
