Apostrophe Added to Formula

Sue Crawford (admin)

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

Cleversheet

Do I correctly infer you're bringing a formula in via Zapier? It seems at first glance it could be better to have Smartsheet handle the formula work, and if necessary bring its building blocks in via Zapier. To achieve that you might need one or more "helper columns".

As to row-specific, have you tried using [Invoice Total]@row instead of [Invoice Total]1?

Andrée Starå

Hi Sue,

I agree with @cleversheet, if it works to keep the formulas in Smartsheet, that would be the simplest solution, and so-called Helper Columns would probably work. If you need to have formulas added from Zapier, it's more advanced, and it doesn't work with just adding the formula text.

I hope that helps!

Happy Holidays!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Cleversheet

Do I correctly infer you're bringing a formula in via Zapier? It seems at first glance it could be better to have Smartsheet handle the formula work, and if necessary bring its building blocks in via Zapier. To achieve that you might need one or more "helper columns".

As to row-specific, have you tried using [Invoice Total]@row instead of [Invoice Total]1?

Andrée Starå

Hi Sue,

I agree with @cleversheet, if it works to keep the formulas in Smartsheet, that would be the simplest solution, and so-called Helper Columns would probably work. If you need to have formulas added from Zapier, it's more advanced, and it doesn't work with just adding the formula text.

I hope that helps!

Happy Holidays!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sue Crawford (admin)

Thanks @cleversheet and @Andrée Starå ! The @row did work to make it row-specific and I tried just copying and pasting the formula into the column and it seems to have worked for now. I still have to test it with more data migrating into Smartsheet from Zapier. Thanks for the quick support!

Andrée Starå

Excellent!

Happy to help!