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
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.
