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

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?





  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭

    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!


    Zach Hall

    Training Delivery Manager / Charter Communications

  • Toby Iverson

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!