)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce’s rolling date filters require pre-configuration for specific periods like “last 30 days” or “last quarter,” limiting your flexibility when you need custom rolling periods for different analysis scenarios.
Here’s how to create truly dynamic rolling date calculations that let users specify any rolling period without creating individual filters for each time frame.
Create flexible rolling date filters using Coefficient
Coefficient overcomes this limitation by enabling truly dynamic rolling date calculations in Google Sheets. You can build rolling period controls that work with any time frame while maintaining live connections to your Salesforce data.
How to make it work
Step 1. Import Salesforce data with all relevant date fields.
Use Coefficient to import your Salesforce data including all date fields you need for rolling analysis (Close Date, Created Date, Activity Date, etc.). This provides the foundation for flexible rolling date calculations.
Step 2. Create rolling period control interface.
Build input cells where users can specify rolling period type (days, weeks, months, quarters), number of periods (e.g., last 90 days, last 6 months), and end date (default to today or custom date). This creates a flexible control panel for any rolling period.
Step 3. Build dynamic date calculation formulas.
Create formulas that automatically calculate the start date based on the rolling period settings. For example: IF rolling 90 days from today, start date = TODAY()-90. These formulas reference your control cells and update automatically when settings change.
Step 4. Configure Coefficient dynamic filtering.
Set up your import to use dynamic filters pointing to these calculated date cells. As users change the rolling period settings, the data automatically filters without requiring new filter creation or import reconfiguration.
Step 5. Set up automated updates and multiple rolling views.
Schedule refreshes so your rolling date view always includes the most current data while maintaining flexible period selection. Create different sections for various rolling metrics (sales pipeline, lead generation, customer activity) all using the same dynamic date logic.
Build rolling date filters that actually work
This eliminates the need to create individual rolling date filters in Salesforce for each specific time period, providing instead a single, flexible interface for any rolling date analysis you need. Get started building dynamic rolling date dashboards today.
