Salesforce dashboard date filter with custom calendar widget for dynamic month selection

Salesforce admins and ops analysts can build custom calendar widgets and on-the-fly date range selectors for Salesforce data in Google Sheets using Coefficient’s Salesforce connector, combining Google Sheets’ native date picker with dynamic Coefficient filters. Salesforce dashboards are limited to pre-configured date ranges like Last 30 Days or This Quarter. There is no way to add a calendar widget or let users select a custom date range on the fly within a native Salesforce dashboard.

A common challenge for ops and RevOps teams: stakeholders want to slice pipeline or activity data by a specific month or custom date window, but native Salesforce dashboards force them to choose from a fixed dropdown. Getting any other view requires building and saving a new report.

How to build a custom calendar date filter for Salesforce data

Step 1. Import your 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, Cases or any other. In the filter settings, add a date field filter and select Dynamic to point it at a specific cell in your sheet rather than a fixed date. This cell will become your date control.

Step 2. Build the month selector in your sheet

In the cell you designated as the date control, set up a data validation dropdown listing months in a readable format — January 2025, February 2025, and so on. For more precise control, add separate start date and end date cells using Google Sheets’ native date picker. Users click the cell to open a calendar and pick their dates. This gives you the calendar widget experience that Salesforce dashboards don’t support.

Step 3. Connect the date picker cells to Coefficient’s dynamic filter

In the Coefficient import settings, update the dynamic filter to reference whichever cell or cells you’re using as date controls. When a user selects a new month or date range from the picker, the next refresh automatically applies that selection as the filter and pulls matching Salesforce data. No one needs to reconfigure the import.

Step 4. Add quick-select options for common date ranges

Alongside the calendar picker, add a secondary dropdown with preset options — This Month, Last Month, Last 90 Days, This Quarter. Use formulas to calculate the corresponding start and end dates and feed them into the filter cells. Users get both the flexibility of a custom date range and the speed of single-click presets.

What you get

Your Salesforce data filters instantly when users change the date selection. Stakeholders can slice pipeline, activity or any other Salesforce object by any month or custom range without needing report access or admin help. For layout reference on how to present Salesforce data alongside interactive controls, see Coefficient’s Salesforce dashboard examples.

Start building custom date filters for your Salesforce data at coefficient.io/get-started.