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