All our playbooks

Learn about tips and tricks for spreadsheets, how to get the most out of your business systems, new product features, and innovative customer use cases.

Creating single source of truth dashboard with business line filter across different Salesforce objects

Build a single source of truth dashboard with business line filtering across multiple Salesforce objects for unified reporting and data consistency.

RevOps
Sales

Creating scheduled deal reports that only export changed records since last week

Create scheduled deal reports that track only changed records since last week using append new data functionality and timestamp tracking for audit trails.

RevOps
Sales

Creating automatic weekly exports that combine deals from multiple pipelines

Create automatic weekly exports combining deals from multiple pipelines with cross-pipeline analysis and stage mapping. Eliminate complex dashboard combinations.

RevOps
Sales

Create Salesforce report showing accounts with pipeline but no closed revenue since date

Build advanced Salesforce revenue analysis reports that combine pipeline data with historical closed revenue filtering using cross-object analysis techniques.

RevOps
Sales

Create exception report in Salesforce for accounts with no closed won opportunities historical data

Build comprehensive Salesforce exception reports for historical opportunity data with advanced analysis techniques that overcome native reporting limitations.

RevOps

Consolidating forecast dashboards with dynamic business line selection across multiple objects

Consolidate multiple forecast dashboards into one dynamic view with business line selection across Opportunities, custom Forecast, and Quota objects.

RevOps
Sales

Cannot proceed past MAP to Details in HubSpot Excel import

Stuck at MAP to Details stage in HubSpot Excel import? Learn how to bypass this common failure point and import contacts successfully using Coefficient.

RevOps

Can you filter Salesforce summary fields for timecard totals below threshold

Understand why Salesforce can't filter summary fields and discover the solution for filtering timecard totals below specific thresholds.

RevOps

Can you combine cross filters with standard filters using OR logic in Salesforce opportunity reports

Find out why you can't combine Salesforce cross filters with standard filters using OR logic and discover the solution that eliminates this restriction.

RevOps

Can HubSpot workflows trigger Excel file creation with custom object data

Discover why HubSpot workflows can't create Excel files and learn a better approach for automated custom object reporting with live data sync.

RevOps

Bulk permission analysis for Salesforce reports shared via manual sharing rules

Analyze Salesforce manual sharing rules in bulk using automated SOQL queries to track ad-hoc report permission assignments and security patterns.

RevOps

Building complex Salesforce opportunity reports with mixed product criteria

Learn how to build complex Salesforce opportunity reports with mixed product criteria when cross filter logic fails to handle advanced filtering requirements.

RevOps
Sales
500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies