)
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.”
Formula fields cannot be mapped to dashboard filters for Activity reports in native Salesforce due to platform limitations where only direct lookup relationships are exposed as filter options.
This restriction is particularly problematic for formula fields that reference data from related objects. Here’s how to recreate formula logic with full filtering capability.
Recreate formula logic with full filtering capability using Coefficient
Salesforce Activity dashboard filters are limited to lookup fields, preventing formula fields from appearing as filter options even when they contain critical business logic.
Coefficient offers a powerful alternative by importing your Activity data into Salesforce spreadsheets where you can recreate formula logic using native spreadsheet formulas that work with dashboard filters.
How to make it work
Step 1. Import Activity report data with all base fields.
Import your Activity report directly from Salesforce using Coefficient, including all standard fields like Owner ID, Account ID, and Status that your formulas reference.
Step 2. Import related object data for formula references.
Create separate imports for Users, Accounts, and other objects that your Salesforce formula fields reference. This gives you access to all the data your formulas need.
Step 3. Recreate formula logic using spreadsheet formulas.
Build spreadsheet formulas that replicate your Salesforce formula field logic. For example, create a “Region” column using =VLOOKUP(OwnerID, Users!A:B, 2, FALSE) or use Coefficient’s =salesforce_lookup function for more complex references.
Step 4. Build filterable dashboards where formula results are regular data.
Add filter controls using Data Validation dropdowns that reference your calculated columns. Create slicers in Excel or filter views in Google Sheets where all formula results become fully filterable.
Step 5. Leverage dynamic filtering with cell references.
Use Coefficient’s filter builder to point filters to cell values for dynamic updates. Apply AND/OR logic combinations and schedule refreshes to keep formula calculations current with live Salesforce data.
Get the formula field filtering Salesforce dashboards lack
This approach provides the formula field filtering capability that native Salesforce dashboards cannot deliver while maintaining data accuracy through automated syncing. Start building formula-powered Activity dashboards today.
