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