Formula to Count Records In A Related Table
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 m...
Forum Discussion
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.