Using Zapier to input formulas

edited 12/09/19 in Smartsheet Basics

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?