Apostrophe Added to Formula

I am trying to take a number from one column and have it automate into another column within a calculation. I am creating a new row through Zapier, which works perfectly...except for the apostrophe.

This is the calculation I am wanting: =(([Invoice Total]1 / 1.15) * 0.15)

But it shows up like this: '=(([Invoice Total]1 / 1.15) * 0.15)


also need this to be row-specific and unsure how to calculate that

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!