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)

Screen Shot 2019-12-23 at 4.20.40 PM.png

Screen Shot 2019-12-23 at 4.20.53 PM.png

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

Find more posts tagged with

Accepted answers

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

All comments

Cleversheet

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

Andrée Starå

Hi Sue,

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.