Hey everyone, looking for some help:
I have a Leads Table and an Estimates table where a Lead can have many estimates.
I am writing a formula in the Leads table that says "If a lead has one or more estimates, Status = In-Progress, otherwise Status = Contacted."
In order for this formula to work, I need a way to aggregate the number of estimate records that have been created in relation to that lead.
Could anyone help me get this figured out?
Thanks!
Josh
Question
Formula to Count Records In A Related Table
+7This topic has been closed for replies.
You need a summary field to count the number of estimate records related to that lead.
Go to your table settings for lead, click relationships, click on the leads to estimates relationship, and then click the add summary field button. No need for filtering, just have it count the number of estimates related to leads and save it.
Let me know how it goes.
Go to your table settings for lead, click relationships, click on the leads to estimates relationship, and then click the add summary field button. No need for filtering, just have it count the number of estimates related to leads and save it.
Let me know how it goes.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.