ContributionsMost RecentMost LikesSolutionsCount 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 ------------------------------ Text Formula Field - Pull text from another field Hi Everyone, I'm trying to create a text field, using a formula, that pulls in data from another field. We use Quickbase to track encounters with clients at a social service agency. There is a question that they fill out at their very first appointment ("What brings you here today?"), and I would like to create a text formula field for subsequent visits that pulls their response to that question (so I just have a formula text box with their answer already filled in). ------------------------------ Rachel Plummer ------------------------------