Formula Column  

Use Case for Sales Representatives  

Sales representatives often need quick visibility into whether their current pipeline is sufficient to achieve assigned targets.

Instead of manually calculating ratios, forecast managers can create Formula Columns that automatically calculate performance metrics.

Example: Pipeline Coverage Ratio  

Pipeline Coverage Ratio=TargetPipeline Amount

This helps sales teams instantly understand:

• Whether pipeline value supports quota achievement

• Which opportunities require prioritization

• Potential forecast gaps

• Overall sales readiness

Once configured, values are automatically updated across the forecast based on the defined formula logic.

How to configure a Formula Column  

Forecast managers can configure Formula Columns using the following steps:

1. Click More Options beside the Forecast Group

2. Select Configure Custom Column

3. Choose Formula Column

4. Define the required formula syntax

5. Save the configuration

After setup, formula values populate automatically throughout the forecast view.

​

Use Case for Managers and Stakeholders  

Organizations often maintain additional forecasting targets outside CRM.

For example:

A sales manager may define a Stretch Goal that exceeds the standard forecast target to motivate teams toward higher performance.

Since these values may change periodically or exist in external planning documents, Import Columns allow businesses to bring those metrics directly into CRM forecasts.

This enables leadership teams to compare:

• Standard forecast targets

• Actual sales performance

• Stretch goals

• Additional business KPIs

from a single forecasting interface.

How to configure an Import Column  

To configure Import Columns:

1. Create an Import Column from Custom Column settings
2. Open More Options for a specific forecast period
3. Select Import Custom Column Data
4. Export the provided sample file
5. Add required values
6. Re-import the file into CRM

Once imported, the data becomes visible directly inside the forecast.

The imported data will then be reflected within the forecast.

Visibility Across Forecast Views  

Configured custom columns appear across both major forecasting interfaces:

1. Forecast List View
2. Breadcrumb View

This allows users to seamlessly review both standard and custom forecasting metrics while navigating forecast hierarchies.

Forecast-Level Column Management  

Previously, column management options were available only at the module level.

With this update, forecast managers can now configure columns individually for each forecast.

Additional improvements include:

1. Forecast-specific column management
2. Custom column arrangement based on reporting priority
3. Independent forecast customization
4. CSV export support for forecasts
   

This gives sales operations teams greater flexibility when building customized forecasting environments.

Why this update matters  

Forecasting requirements vary significantly across organizations, and standard sales metrics are often not enough for strategic planning.

With Custom Columns in Forecasts, businesses can now:

• Track organization-specific KPIs

• Improve forecast visibility

• Align forecasting with business goals

• Reduce dependency on spreadsheets

• Build more meaningful sales reports

• Improve revenue planning accuracy

By bringing customized forecasting metrics directly into Zoho CRM, organizations can create a more flexible and data-driven sales forecasting process.

 For more information, please visit www.pfc-group.com.