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

Toby Iverson

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)

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!

Toby Iverson

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

Thanks!