Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
Currently Change Value converts any formula added to text.
Remove the " ' " to allow functioning formula to be automatically added
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.
This idea would be a huge change for the better and bring Smartsheet closer in line to competitors in terms of functionality. While we don't have a datetime field, being able to record calculated values that were triggered by automations allow for time stamps, recording who submitted information to a certain field (and keeping the name static), etc.
This SHOULD be a straightforward change - DON'T modify the Automation change cell value text box entry at all.
Rather, Smartsheet should transfer the exact entry to the sheet, and not add a text apostrophe " ' " to the start.
If we wanted a number or a formula to be treated as text, we would put our own apostrophe in front.
Sign in to comment or add your vote.
