)
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 Activity dashboard filters are limited to displaying only direct lookup relationships like Account, Contact, Lead, and Opportunity because of fundamental platform constraints that prevent formula fields from appearing as filter options.
This severely limits filtering options for complex reporting needs where formula fields contain critical business logic. Here’s how to make all field types filterable.
Make all Activity fields filterable including formula fields using Coefficient
The technical constraint exists because Salesforce Activity objects can only expose direct lookup relationships in dashboard filters, blocking access to formula fields that calculate or reference data from related objects.
Coefficient overcomes this limitation by importing your Activity data into Salesforce spreadsheets where you can recreate formula logic and make every field type filterable.
How to make it work
Step 1. Import Activity data with all available fields.
Use Coefficient’s Salesforce connector to import your Activity data including all standard fields like Subject, Status, Owner ID, and any custom fields that are accessible through the API.
Step 2. Import related object data separately.
Create additional imports for Users, Accounts, and other objects that your Salesforce formula fields reference. This gives you access to all the data needed to recreate formula logic in your spreadsheet.
Step 3. Recreate formula logic in spreadsheet columns.
Build spreadsheet formulas that replicate your Salesforce formula fields. For example: =IF(VLOOKUP(B2,Users!A:C,3,FALSE)=”West”,”High Priority”,”Standard”) recreates priority logic based on User region data.
Step 4. Create comprehensive filter controls.
Build dropdown filters, slicers, or custom filter controls for all columns including your recreated formula results. Apply complex filter logic combining lookup and formula fields that Salesforce dashboards cannot handle.
Step 5. Use advanced filtering with dynamic references.
Leverage Coefficient’s advanced filtering with AND/OR conditions, reference cell values for dynamic filtering, and create cascading filters where formula field selections update other filter options automatically.
Get full filtering capability across all field types
This approach provides complete filtering capability across lookup, formula, and custom fields that Salesforce dashboards cannot deliver for Activity reports. Start building comprehensive Activity filters today.
