Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoYou will need to add more summary fields for each of these
How many leads did we get last week?
How many leads in the last 2 weeks?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
How many leads did we get last week?
How many leads in the last 2 weeks?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MathewCrist
4 years agoQrew Member
Thanks Mark, and so when I do that, I would need to add a formula to the summary field?
If so, I may need some help on what that formula would look like.
Best,
Matt
------------------------------
Mathew Crist
------------------------------
If so, I may need some help on what that formula would look like.
Best,
Matt
------------------------------
Mathew Crist
------------------------------
- MichaelTamoush4 years agoQrew CaptainMatthew,
To answer your last question, you would add filters to your summary field. I'm assuming you have a field in your leads table that is something like [Date Lead Acquired].
So your summary field for # of leads acquired last week could be something like:
Number of leads where:
[Date Lead Acquired] is on or after 7 days in the past.
ā
------------------------------
Mike Tamoush
------------------------------