Automating formula into a cell is adding a apostrophe and breaking formula

Options
Toby Iverson
Toby Iverson ✭✭
edited 12/08/23 in Formulas and Functions

When a row is added through a form I want to add formulas to certain columns The automation mostly works but adds a "'" at the beginning of the line so it does not work. Does anyone have ideas why? how to get around it?

=SUM([Item1]@row:[Item2]@row)

Becomes

'=SUM([Item1]@row:[Item2]@row)

Answers

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭
    Options

    Automation currently doesn't have the ability add a formula. It is adding it as text only, which is why the ' is there.

    Is there a reason you couldn't create a column with a column formula to generate with the results you need for each submission? That would be my recommendation for this type of scenario.

    I hope this helps!

    Best,

    Zach Hall

    Training Delivery Manager / Charter Communications

  • Toby Iverson
    Options

    Oh, I didn't column formula was a thing!

    Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!