Spreadsheet Formula for empty repsonse

Status: Open · Asked by Shane Harris on · 0 views

shane6836 — Question ·

Need to be able to generate an output (1 for true, 0 for false or something similar) that can be passed into Documentaro (being used to show or hide sections based on if there is content or not).

Basically, need to look at an earlier action (such as a record search from Airtable) and if there is any response then set output to 1, or if no response, output to 0.

Been trying to achieve this with the Pabbly Number Formatter Spreadsheet Formula, but not having much luck - any ideas?

Soumya Tripathi — Reply ·

Hello @shane6836
Kindly let us know your workflow ID.

Please be aware that to assist you effectively, we may need to access your Pabbly Connect account. If you're comfortable with this, please grant us permission by stating in your next email: "You have my permission to log into my Pabbly Connect account, and edit workflow {If required}. Here is the registered email address associated with it."

Back to all forum threads · Log in to reply