Knowledge Base
How can we help?
Full Site Search

How do I query for empty values?

If you want to query for empty values, please refer to this document.

Ragic currently does not support querying for empty values for the "Select from other sheet" field type. A workaround to query for empty values would work as described below:

Step 1. Create a new free text field

Step 2. Configure formulas so that the field value of new field will equal to the field you would like to query

Step 3. Run a formula recalculation to populate values for your new field.

With this method, you'll be able to query the empty value from your new field.

Top of Page
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com