Skip to main content
Question

Formula that calculates # of lead in past week

  • May 12, 2021
  • 0 replies
  • 31 views

Hi,

We have a numeric (summary) field that calculates our # of leads (all time). This is a lookup field. 

So, if we have 30 leads all time from Facebook, I can easily see that in a report by displaying the "# of leads" field. 

However, I would like to also show in the report how many leads did we get last week? How many leads in the last 2 weeks?

Is there a way to do this using Report Formulas, or by creating a field with a formula? Other suggestions?

Here's a couple of screenshots to help you see what I am seeing...

​

Thanks!

Matt

------------------------------
Mathew Crist
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You 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
------------------------------