One Pace Google Sheets ^hot^ [ FHD ]

| A | B | C | D | E | F | G | |---|---|---|---|---|---|---| | | Episodes (Pace) | Runtime (hrs) | Status | Date Started | Date Completed | Notes | Step 2: Input the One Pace Arc List Here is the core data to copy into your sheet (based on the standard One Pace release order up to recent arcs). Fill columns A, B, and C.

=COUNTIF(D2:D28, "Completed") Next to it, add: Arcs Completed out of =COUNTA(A2:A28) In cell C30 (or any summary area), add: one pace google sheets

function onEdit(e) var range = e.range; var sheet = range.getSheet(); var col = range.getColumn(); var row = range.getRow(); if (col === 4 && row > 1) // Column D is Status sheet.getRange(row, 8).setValue(new Date()); // Column H gets today's date | A | B | C | D

Create the following column headers (A–G): Change "Completed" to "Watching" to see remaining runtime

=SUMIF(D2:D28, "Completed", C2:C28) This shows total hours watched. Change "Completed" to "Watching" to see remaining runtime. In column H (add a header Last Activity ), use this script (requires Apps Script – simple version):

Save and run once to authorize. Now any status change logs the date. 1. Episode-to-Pace Conversion Helper Create a second sheet (tab) called Episode Lookup . Column A: Original OP episodes (1–1000+). Column B: Corresponding One Pace episode/file. Use vlookup to find where you are.