Create and edit calculated fields in Google Sheets pivot tables

Create and edit calculated fields in Google Sheets pivot tables with an improved editor

We are introducing a new, dedicated formula editor dialog for creating and editing calculated fields within pivot tables in Google Sheets. This update streamlines how you build custom formulas and derived metrics, making data analysis faster and more accurate.

Specifically, this new update introduces:

A dedicated formula editor dialog for creating and modifying custom calculations
Field selection menus to insert column names without manual typing
Real-time syntax and formula validation to catch errors before applying changes

Previously, creating calculated fields in Google Sheets required entering formulas into inline sidebar cards, which involved manual typing of exact field names and lacked live error checking. With this update, calculated fields can be created and managed with greater speed and accuracy, ensuring formulas remain consistent and easy to maintain across spreadsheets.

Getting started

Admins: There is no admin control for this feature.
End users: Visit the Help Center to learn more about creating and using pivot tables in Google Sheets.

Rollout pace

Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) started on September 8, 2026
Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 21, 2026

Availability

Available to all Google Workspace customers and users with personal Google accounts

Resources

Google Docs Editors Help: Create & use pivot tables

How to create a Pivot table in Google Sheets - Sheetgo

Google has introduced a dedicated formula editor dialog for creating and editing calculated fields within pivot tables in Google Sheets, replacing the old, cramped inline sidebar cards. This update is designed to make data analysis faster and more accurate by reducing formula errors and eliminating manual typing. [1]

Key Enhancements in the New Editor

Dedicated Dialog Box: Instead of squinting at a tiny inline field in the sidebar, you now write custom calculations in a spacious, dedicated formula window. [1]
Field Selection Menus: You no longer need to type exact column header names manually. You can select them directly from interactive tabs to instantly insert them into your formula. [1, 2, 3]
Function Insertion Menus: Easily browse and insert built-in math and statistical functions directly inside the editor. [2, 3]
Real-Time Validation: The editor checks your syntax live. A green checkmark indicates a valid formula, while a red exclamation mark flags an error so you can fix it before saving. [1, 3]

How to Create or Edit a Calculated Field

You can use the new editor by following these steps on your computer: [2]

Open the Editor: Open your spreadsheet in Google Sheets. Click the Edit button that pops up underneath or next to your pivot table to open the sidebar. [2]
Add a Field: Look for the Values section in the side panel, click Add, and select Calculated field. [2, 3]
Build Your Formula: The new structured dialog box will appear.
- Give your field a custom name.
- Use the Columns tab to insert your fields without typing.
- Use the Functions tab to add your logic. [2, 3]
Choose the Aggregation Type:
- To use basic built-in math (like adding up a single column), leave Summarise by as SUM.
- To use math across multiple columns (e.g., =SUM(Revenue) - SUM(Cost)), switch Summarise by to Custom. [3, 4]
Save: Look for the green syntax validation indicator and click Add or Save at the bottom right to apply the changes to your pivot table. [3]