One Pace Google Sheets Extra Quality Direct

For automatic: → paste:

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

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. For automatic: → paste: Or simpler: manually enter

Example formula in main sheet:

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 Column B: Corresponding One Pace episode/file

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

Why This Paper is Helpful One Pace is a fantastic resource for fans who want to experience One Piece closer to the manga’s pacing. However, because it’s a fan project distributed across torrents, Telegram, and various archives, it’s easy to lose track of which arcs you’ve watched, which episodes you’ve downloaded, or where you left off. Google Sheets solves this by offering a free, cloud-based, accessible-from-anywhere progress tracker. Part 1: Setting Up Your One Pace Tracker in Google Sheets Step 1: Create the Basic Structure Open Google Sheets and create a new spreadsheet. Name it One Pace Tracker - [Your Name] .