Google Sheets | One Pace

=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):

Or simpler: manually enter =TODAY() in column H when you change Status to “Watching” or “Completed”.

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. 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

| Arc | Episodes (Pace) | Runtime (hrs) | Status | Date Started | Date Completed | Notes | |---|---|---|---|---|---|---| | Dressrosa | 48 | 21 | Completed | 2025-02-10 | 2025-03-01 | Skip original eps 630-700; much better pacing | Install Google Sheets on your phone. Pin the sheet to your home screen. After watching a batch of One Pace episodes, open the sheet, tap the arc’s Status dropdown, and change it. It takes 5 seconds and saves you from rewatching the same arc months later. Conclusion: One Pace fixes the anime; Google Sheets fixes your memory. With this setup, you’ll never ask “What arc was I on?” again. Enjoy your filler-free journey to Laugh Tale. Save and run once to authorize

For automatic: → paste:

=COUNTIF(D2:D28, "Completed") Next to it, add: Arcs Completed out of =COUNTA(A2:A28) In cell C30 (or any summary area), add: With this setup

Create the following column headers (A–G):