The Quick Base Community will be read-only from August 19th-23rd while we finalize the updates to launch our new community site. On August 23rd the new community site will be live and accessible right here at this same URL with the full launch on August 27th with a special AMA with Jay Jamison on our exciting Cloudpipes news.
If you run into an issue while we are working on our migration you can reach out to our Care team via a Care case for help. There is a link to submit a case right on the Community home page or at our Contact Us page at www.quickbase.com. Thank you for your patience while we work behind the scenes.
I am trying to create a summary variable that counts a set of fields if they are not null or do not contain a specific variable (e.g., "Not Applicable"). Can the count function be used in combination with case or if statements to achieve this?
What you need to do is move your boolean logic into a checkbox formula field in the child table. Thenm when creating the summary field, all you need to do for a filter is reference that single field as checked/true.