)
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 Sales Ops analysts can access all Activity fields including formula fields and related User custom fields for filtering by importing Task and Event data into Google Sheets or Excel using Coefficient’s Salesforce connector and recreating formula logic as spreadsheet columns. Formula fields do not appear in Salesforce dashboard filter mapping for Activity object reports. This is a known platform limitation: the Activity object’s restricted field exposure rules mean the dashboard filter system does not recognise formula fields as filterable options, even when those fields reference critical business data such as a User’s Sales Region or Territory.
A common challenge for Sales Ops teams: they build a formula field on the Activity object to surface a rep’s sales region from the User object and then discover it is completely invisible in dashboard filters. The field works in the report, but the dashboard cannot use it for filtering.
How to access Activity formula fields for dashboard filtering
Step 1. Import Activity data with direct User field access
Open Coefficient in Google Sheets or Excel and select Import from Salesforce. Use From Objects and Fields and select the Task object. In the field selector, look for User relationship fields using the Owner dot notation, for example Owner.Sales_Region__c, which pulls the User’s custom field value directly into the Activity row without needing a formula field on the Activity object. Do the same for the Event object in a separate import. This bypasses the formula field limitation entirely.
Step 2. Import related object data for formula reconstruction
Create a second import for the User object, pulling Id and any custom fields your formula fields reference: Sales Region, Territory, Team, Manager or any other classification. This import gives you the raw field values. You can now VLOOKUP from your Activity import using OwnerId to pull the correct value for each activity row.
Step 3. Recreate formula logic as spreadsheet columns
Add formula columns to your Activity sheet that replicate what your Salesforce formula fields were doing. For a region lookup, use VLOOKUP against your User import with OwnerId as the key. For more complex logic, use IF statements or nested lookups. The result is a regular column containing the correct value for every row, fully filterable by any spreadsheet filter mechanism, with no platform restriction.
Step 4. Build filter controls and schedule refresh
Add data validation dropdowns above your Activity data referencing the recreated formula columns. Use filter views in Google Sheets or slicers in Excel so team members can slice by region, territory or any other dimension. Set a daily refresh schedule in Coefficient so Activity data and User data both stay current, keeping your filter values accurate.
What you get
Every field you need for Activity filtering is available, regardless of what Salesforce’s dashboard filter mapping exposes. Sales Ops teams stop working around the formula field limitation and build the Activity analysis they actually need. Field values update daily without anyone touching the import configuration.
Start building unrestricted Activity dashboard filters today at coefficient.io/get-started.
