Welcome!

Using Zapier to input formulas

Hi, I have been trying to use zapier to import a VLOOKUP formula, and the formula leaves Zapier clean, but in smartsheet it wraps in a single quote,

example '=VLOOKUP([Sales Order #]4, {SL_MS_PM ALL}, 11, false) but when I enter it without the = the single quote does not happen as soon as a string starts with a = it adds the ' to the front of = like this '=

Zapier tells me that the formula leaves their system without the quote, and thought I should check with smartsheet, just wondering is there a way around it?

thanks.

Find more posts tagged with

Comments

Shaine Greenwood

Hello,

It's possible that you're putting the VLOOKUP function in a cell that doesn't support formulas. When a cell doesn't support formulas, they'll be turned into text with a single quote in front of them. More information on cells that can't contain formulas is available in the help center: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet#noformula

Rochelle from Agilize

Hi Shaine,

I'm having the same issue here. I'm trying to use Zapier to input formulas into a Text/Number column (which does support formulas) and it still comes over as a text string: '=INDEX(PARENT(), 1)

I'm using SCC with creates new rows on a sheet via cell links, but the auto-fill function doesn't seem to work in this case; hence trying to use Zapier as a workaround.

Any idea why this is?

Sign in to join the conversation!

Quick Links

Trending discussions

Referencing to Smartsheet table (consisting of 30+ columns) in INDEX/MATCH formula but shows error
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
Upgrade user mismatch
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
Delete
How can I delete old sheets I no longer use from my account?