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
-
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?
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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?
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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!
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!