All our playbooks

How to calculate and display sales velocity on a Salesforce leaderboard dashboard

Learn to calculate sales velocity in Salesforce dashboards with automated formulas. Track pipeline speed and rep performance with real-time updates.

How to calculate ACV in Salesforce when mixing one-time implementation fees with recurring subscription revenue

Learn how to accurately calculate ACV in Salesforce by separating implementation fees from recurring revenue using advanced spreadsheet formulas and live data.

How to combine lead and contact activity reports in Salesforce into single unified report

Learn how to create unified activity reports combining Salesforce lead and contact data in one view with step-by-step instructions and automated solutions.

Connect live data feeds to Excel spreadsheets in Office 365

Connect live data feeds to Excel in Office 365 with reliable, real-time connections that maintain performance and don't break when files are moved.

How to copy Salesforce reports to new folders when you can’t move subfolders

Learn how to copy Salesforce reports to new folders when subfolder moves are blocked by permissions, plus a better approach for report organization.

How to create custom Salesforce reports for tracking @ mentions in Chatter

Track @ mentions in Salesforce Chatter with custom reports that capture mention data, user activity, and engagement patterns using advanced filtering and automation.

How to export all profiles with edit access to specific Salesforce objects

Learn how to export all Salesforce profiles with edit access to specific objects using custom SOQL queries and automated reporting instead of manual checking.

How to enable HTML Email Status report type in Salesforce report builder

HTML Email Status report missing from Salesforce? Skip the complex setup and access email tracking data directly through alternative methods that work instantly.

How to filter accounts by opportunity count in Salesforce reports without using SQL

Learn how to filter Salesforce accounts by opportunity count without SQL using Coefficient's data integration and spreadsheet aggregation features.

How to generate object permission matrix report for all profiles in Salesforce

Generate comprehensive object permission matrix reports for all Salesforce profiles using custom SOQL queries and automated pivot table creation in spreadsheets.

How to handle case-sensitive Salesforce IDs in Excel VLOOKUP

Solve case-sensitive Salesforce ID issues in Excel VLOOKUP. Learn how to handle 15-character and 18-character ID case sensitivity automatically.

How to recreate Google Sheets workflow automations in Microsoft Excel

Migrate Google Sheets automation workflows to Excel using no-code solutions that replicate add-on integrations, scheduled refreshes, and real-time data sync.