Help

Sheet periods

Run a sheet by calendar month, from your payday, or for fixed dates like a trip.

On the web and the iPhone app

Try it

Choose how the sheet runs. The timeline redraws.

Starts on day
25th

Each cycle runs from the 25th to the day before the next 25th.

25 Oct – 24 Nov31 days
25 Nov – 24 Dec30 days
25 Dec – 24 Jan31 days
25 Jan – 24 Feb31 days

Targets, Year, Insights and exports follow these periods.

Sample data. Nothing here changes your sheets.

How to use it

  1. Step 1 of 4: Open the sheet’s settings. Under Period, tap Runs by.
  2. Step 2 of 4: Pick Month, Cycle (then the day it starts, like your payday) or Fixed dates (a start and an end).
  3. Step 3 of 4: For Month or Cycle, under Apply to, choose From now on to keep past periods as they are, or All months (All cycles) to redraw them.
  4. Step 4 of 4: Tap Save. Targets, Year, Insights and exports now follow your periods.

Where to find it

On the web
Sheet settings › General › Period
On iPhone
Sheet settings › Period

Good to know

  • A cycle that starts on the 29th–31st starts on the last day in shorter months.
  • After fixed dates, the sheet can Go back to its usual periods or End here.
  • Only the sheet’s owner can change its period.