Back Office BeatSubscribe

Published by J9 Systems. What's new in business tech, and what it means for yours.

From the brief of Monday, November 2, 2026 · No. 18

From the daily brief · Software

Google Sheets adds compact pivot table layout, Oct. 30: a small help for job costing

If your job costing or crew schedule runs through a Sheets pivot table, a new layout option reduces sideways scrolling but changes no numbers and costs nothing.

By Carter Josephson · · 1 min read

What happened

Google's Workspace Updates blog said in its Oct. 30, 2026 weekly recap that Google Sheets now supports compact form layout for pivot tables. Google says the layout keeps multi-level pivot tables readable while reducing excessive horizontal scrolling.

What it means for a 10-to-50-person business

This is a display change, not a new feature for calculating anything. Take an 18-person remodeling contractor that logs every cost in one sheet with columns for Job, Phase, Cost code, Vendor and Amount. A pivot table grouped by Job, then Phase, then Cost code usually spreads those labels across three columns before the dollar figures start. With a few months of data, the office manager scrolls right to see totals and loses track of which job a row belongs to. Compact form is designed to stack those levels so the table stays narrow, which should make the report easier to read on a laptop or to screenshot for a weekly job review. The effect is small. Expect a few minutes saved a week, not a better margin. Care if you build multi-level pivots in Sheets for job costing, crew hours or schedules. Ignore it if your job cost reports come from QuickBooks, Buildertrend or JobTread, or if your pivots have only one row level. The recap does not say which Workspace editions get it or when rollout finishes, so check the linked post.

What to do
Try it

Open your busiest job-costing or scheduling pivot table this month and switch it to compact form layout to see whether it reads better for the person who reviews it.

What it costs
What it costs
Plan or price change
$0 (part of Google Sheets; no new fee in the announcement)
Time to test on one existing pivot
15 min (≈ $13 at $50/hr)
Scrolling time saved, assume 5 min/week for one office manager
≈ 4 hrs/yr (≈ $200 at $50/hr)
Doing nothing
$0; this is a layout option, not a price or plan change
Sources
workspaceupdates.googleblog.com (primary) · Google Workspace release calendar

Questions owners ask

Do I need Gemini or a paid add-on to use compact pivot tables?

The recap lists it as a Google Sheets feature and does not tie it to Gemini. It does not say which Workspace editions get it, so check the linked post or your admin console.

Will switching layouts change my totals?

No. Google describes it as a layout for readability. The underlying data and calculations stay the same.

What about the Fill with Gemini citations in the same recap?

Sheets' AI function now shows the web sources it used inside each cell. That matters if you use it to pull outside data such as supplier details. Most job costing runs on your own numbers, so it is less relevant for that use.

Three to five of these, every weekday morning.

Related