Spreadsheet Formula for empty repsonse

[shane6836]

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]

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."