
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 13, 2022 10:24 AM
Hi,
For each record, I have a start date (Date de parution) and an end date (Date 6 mois). They unique to every record.
I want to count how many we have sold of every record within those date (Sales are in the Ventes 2021 tab, which is already link to my working tab).
I cannot filter by a Date field, it seems. How can I work around this?
Thank you
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 05:14 AM
Hi Veronique, would the following work?
- We create rollup fields in
Ventes 2021
of bothDate de parution
andDate 6 mois
- In
Ventes 2021
, we create a formula field that checks whether the record’sDate
value is between the rolled up values ofDate de parution
andDate 6 mois
from the previous stem - In the
Titres
table, we modifyVentes 6 mois
’s to conditionally filter on the formula field from step 2?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 05:14 AM
Hi Veronique, would the following work?
- We create rollup fields in
Ventes 2021
of bothDate de parution
andDate 6 mois
- In
Ventes 2021
, we create a formula field that checks whether the record’sDate
value is between the rolled up values ofDate de parution
andDate 6 mois
from the previous stem - In the
Titres
table, we modifyVentes 6 mois
’s to conditionally filter on the formula field from step 2?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 08:07 AM
What would be the formula for .2? I’m trying a SUMIF but it doesn’t seem to work.
Thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 11:07 PM
Hi Veronique, I would use this formula:
IF(
AND(
Date <= {End Date (from Titres)},
Date >= {Start Date (from Titres)}
),
1
)
I’ve also set it up here for you to have a look at
To view the formulas, you can duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 15, 2022 05:04 AM
Thank you so much @Adam_TheTimeSavingCo
