Zap: Google Sheet to ServiceM8 Problem: Dynamic value generated by formula in Google Sheet turns into “???” when transferred into ServiceM8 Context: Used to work fine a couple weeks ago, still works when doing testing before publishing, only “???” shows up in live version Request: is there a setting I need to tweak, redo the Zap, or is there a workaround, like an extra step to turn the formula into a hard-coded value? Thanks for your guidance

Question

Google Sheet Dynamic Formula Value Cannot be Transferred

Zap: Google Sheet to ServiceM8
Problem: Dynamic value generated by formula in Google Sheet turns into “???” when transferred into ServiceM8
Context: Used to work fine a couple weeks ago, still works when doing testing before publishing, only “???” shows up in live version
Request: is there a setting I need to tweak, redo the Zap, or is there a workaround, like an extra step to turn the formula into a hard-coded value? Thanks for your guidance

Did this topic help you find an answer to your question?

+14

Hi @Lucy Lu

Good question.

We would need to see specific examples and screenshots with how your Zap steps are configured to have enough context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor