Change Cell Value Automation - Can I add a formula to the cell?

Moxam

I also want to use automation to change the value in a cell to a formula. Has any progress been made on this suggestion?

MHalvey

I would like to add my vote for this too! It would be nice to use automations to add specific formulas in them base on the conditions.

trenner

Another vote for this functionality. Can't believe it's not in already.

BecH.

I NEED this functionality as well. It would be such a time-saver and hoping this will help bump this up on the priority.

ChristopherM

One more vote for this. I could really use this ability now.

It would also be great to be able to add formulas to a contact list column as well, especially considering that we cannot use groups in a contact list column.

SomeRando

This is a required and needed functionality. If there's a way to remove the ' from the cell move, that would be ideal.

For now, I'm manually removing the ' from each row when it's added. Super cumbersome.

Fred Tepera

I also would find this very helpful to be able to insert a formula into a cell using an automation. This and being able to copy dependencies between rows when coping them from one sheet to another would greatly increase the value of the tool.

Nicholas Aspey

bump

robert.hayden

Bump. This is a frustrating one.

Genevieve P.

Hi all,

Just a reminder that the Get Help section of the Community is a place to ask questions and get help with the Smartsheet application - if you have feature requests and suggestions for how Smartsheet can improve, please either vote on or create ideas in the Product Feedback and Ideas topic. This is the only area that is reviewed by the Product team.

For this specific request, feel free to leave your comments and votes on this Product Idea:

https://community.smartsheet.com/discussion/104469/allow-change-value-in-automations-to-add-a-functioning-formula

Cheers,

Genevieve

CeliaC

I'm responding only to the original question:

What do you want the target cell value to be if the value of the trigger column ("type")/cell@row is not "section"?

Currently, I think a column formula with several levels of IF() formula can get the job done, e.g. =IF([type]@row = "section", SUM(CHILDREN()), "value if [type]@row <> "section")

Manuel Perez

Its not the best solution but just leave the cell blank... Hear me out - If you have the formula in at least two rows directly above then the formula will auto populate into the cells below as rows are added. This has worked for me when user submit things to my Form.

Claire Lou

Having a formula populate a cell value through automation would be immensely helpful! I'm trying to update a cell automatically based on a users input, but not for all rows. If the user selects A, then do nothing, but if user selects B, then =[column1]@row+[column2]@row.

MHalvey

https://community.smartsheet.com/discussion/comment/433531#Comment_433531

Hi @Claire Lou - I've found making specific column formula IF statements can help in some situations with multiple options needed. I don't fully know your case but first thought after reading it was an IF statement looking for A then blank cell, but if B then join those cells, if they are numbers.

You can build a string of situational IF statements if need for multiple options. I hope this gives you some ideas or workarounds. 😀

Michael

Claire Lou

Thanks @MHalvey —- I appreciate your response. I understand I can create a separate cell for that however, I have an intake form. I'd like to ask them to name their items but not when it's a bug or admin item. If it's either of those two things, then I'd want the automation to automatically concatenate IntakeType+UniqueID. I can create a separate column to create this value but even with automation, it won't let me change the cell type to anything other than text input.