)
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 admins and ops analysts can build a Google Analytics-style calendar picker for Salesforce data in Google Sheets using Coefficient’s Salesforce connector and dynamic cell-based filters, with all charts and summary metrics updating instantly when the date range changes. Salesforce dashboards are limited to pre-configured date ranges. There is no calendar picker, no custom start and end date input and no way to let users define an arbitrary time window without an admin creating a new report.
A common challenge for RevOps teams: stakeholders want to slice pipeline or activity data by a specific date window for a board meeting or QBR, but native Salesforce dashboards force a fixed selection. Getting any other view means building and saving a new report, which is exactly the wrong person to involve at the moment the data is needed.
How to build a calendar picker date filter for Salesforce data
Step 1. Import Salesforce data with a dynamic date filter
Open Coefficient in Google Sheets and select Import from Salesforce. Choose your object or existing report, Opportunities, Activities, Leads or any other. In the filter settings, select your date field, set the condition to Dynamic and point it at a specific cell in your sheet. That cell becomes your date control, whatever value is in it drives what data pulls on the next refresh.
Step 2. Set up start and end date cells as calendar pickers
Designate two cells in your sheet as Start Date and End Date. Format both cells as dates, Google Sheets automatically adds a calendar picker icon when a date-formatted cell is clicked. Label them clearly so anyone opening the sheet knows where to change the range. These two cells are the only controls your stakeholders need to interact with.
Step 3. Configure dynamic filtering with AND logic across both date cells
In the Coefficient filter settings, set up two dynamic filter conditions: your date field is greater than or equal to the Start Date cell, AND less than or equal to the End Date cell. When a user selects a new date range using the calendar pickers, the next refresh pulls only records that fall within that window, no import reconfiguration required.
Step 4. Add quick-select preset formulas for common ranges
Alongside the calendar pickers, add a dropdown with preset options, This Month, Last Month, Last 90 Days, This Quarter and use formulas to calculate and populate the Start Date and End Date cells automatically when a preset is selected. Users can choose a preset for speed or use the calendar pickers for a custom range.
What you get
Your Salesforce data responds to any date range your team specifies, without rebuilding reports or involving an admin. Charts, pivot tables and summary metrics all update when the date selection changes. For reference on how to structure Salesforce data in a shareable dashboard, see Coefficient’s Salesforce dashboard examples.
Start building interactive date filters for your Salesforce data today at coefficient.io/get-started.
