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…
As the smartsheet admin for Europe, it would be extremely helpful to be able to view all Automations / recurring emailed reports in one place as opposed to sheet level. It's almost impossible to ensure everything is working correctly / delete recurring emailed reports without this.
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
