RachelPlummer
9 months agoQrew Member
Count Formula with Conditions
Hi all, we use Quickbase as a CRM for client encounters at our social services organization. I'm looking for help creating a "count" formula based off of a text field.
We have a table called "Service Subcategory" which is nested in a table called "Encounter" (so within 1 encounter, a client may have received many different services, called service subcategories). I want a count of the number of times a client received the "Hoarding" service subcategory in the past quarter. So for a given client, counting across all "Service Subcategory" instances... could anyone help with this case / with writing a formula?
Thank you!
Rachel
------------------------------
Rachel Plummer
------------------------------