How to build a Google Sheets tracker for your checklist

Manually checking off national parks or ballparks on a paper passport works fine until you want to sort by state, tally your progress by region, or share your list with a travel partner. A Google Sheets checklist tracker turns your Triptyka bucket-list passport into a living spreadsheet: type in the names, set up checkboxes and counters, and watch your progress update automatically every time you visit.

Why this matters

A printable checklist is great for a road trip glovebox or a wall in the den, but it doesn't total your progress or let you filter by region when you're planning next year's trip. Spreadsheets do both. If you'd rather keep things digital-only and never print anything, syncing your printable checklist to Google Drive gets your PDF into the same ecosystem as the sheet you're about to build, so both live in one folder.

Google Sheets also beats a plain document because it's free, works on any device with a browser, and lets you build formulas without installing anything. For a 30-item MLB ballpark list or a 63-park National Park Service passport, that's the difference between a static PDF and a tool that tells you exactly how close you are to finishing in 2026.

Before you start

• A free Google account. You need this for Sheets and Drive access — no paid tier required.
• Your Triptyka checklist data on hand. Have the PDF or the item list open in another tab so you can copy names, locations, and categories directly into rows.
• The gotcha: don't build checkboxes with plain text such as a typed Y or X — use Sheets' native checkbox data type from the start. Retrofitting checkboxes onto a column that already has typed text means re-entering every row, and on a 50-plus item list that's an hour you don't get back.

Set up your checklist sheet

Import your checklist data

1. Open Google Sheets and create a Blank spreadsheet.
2. In row 1, add headers: Name, Location, Category (optional), Visited, Date Visited, Notes.
3. Copy the item names from your Triptyka passport (park names, ballpark names, distillery names, whatever list you're tracking) into the Name column, one per row.
4. Fill in Location for each row so you can sort or filter by state or region later.

Expected result: a clean list with every checklist item in its own row and no blank gaps.

Build your checkbox column

1. Select the entire Visited column (click the column letter, not just the header cell).
2. Go to Insert in the top menu, then click Checkbox.
3. Every cell in that column now shows an empty checkbox. Click one to mark an item complete — the cell value becomes TRUE behind the scenes.

Expected result: clicking any checkbox in the Visited column toggles it between checked and unchecked instantly.

Add progress tracking

1. In a blank cell below your list (say, cell D1 if your data ends at row 40), type: =COUNTIF(D2:D40,TRUE)
2. In the cell next to it, type =COUNTA(A2:A40) to get your total item count.
3. Divide the two: =COUNTIF(D2:D40,TRUE)/COUNTA(A2:A40) and format that cell as a percentage using Format > Number > Percent.

Expected result: a live percentage that climbs every time you check a new box — 12 of 30 ballparks visited shows as 40%, automatically, no manual math.

Add conditional formatting for visual progress

1. Select your full data range (A2:F40 or wherever your rows end).
2. Go to Format > Conditional formatting.
3. Under Format cells if, choose Custom formula is and enter =$D2=TRUE.
4. Set the fill color to a light green and click Done.

Expected result: every row you mark visited turns green, so a 60-row national parks list becomes scannable in one glance — green rows done, white rows still ahead.

Track visit dates and notes, not just checkmarks

If you want more than a checkmark — say, the exact date you played a course on your golf checklist, or which pour you tried at a distillery — expand the Date Visited and Notes columns instead of leaving them blank. Use Insert > Date for a quick date picker in the Date Visited cell, and just type free text in Notes.

This turns the same sheet into a trip journal, not just a completion tracker. It's the version most collectors keep long-term, because checkmarks alone don't capture the story of the visit. For a multi-year list you'll be adding to through 2026 and beyond, the notes column is what makes the sheet worth reopening.

Troubleshooting

• Checkboxes show TRUE/FALSE instead of a box shape. You typed text into the cell before applying checkboxes. Delete the cell contents, re-select the column, and re-apply Insert > Checkbox.
• COUNTIF formula returns 0 even after checking boxes. Your range reference doesn't match your checkbox column exactly — double-check the column letter and row range in the formula.
• Conditional formatting doesn't turn rows green. The custom formula needs a $ before the column letter (like $D2) so it locks to that column while scanning every row. Without it, the rule compares the wrong cell and often fails silently.
• Sheet doesn't update on my phone. Google Sheets syncs through your Google account, not local storage — confirm you're signed into the same account on mobile as you used to create the sheet.
• List got too long to scan. Add a filter view (Data > Create a filter) so you can hide completed rows and see only what's left.

Customize your tracker

Once the base google sheets checklist tracker works, the obvious next moves are sorting by region for road-trip planning, adding a second tab per category if you're tracking more than one Triptyka passport at once, or duplicating the sheet as a template you reuse for every new list you buy in 2026.

If spreadsheets aren't your thing and you'd rather work inside a note-taking app, turning your printable checklist into a Notion tracker covers the same idea with databases and tags instead of formulas. If you're weighing a dedicated app against a DIY spreadsheet, the Triptyka vs. Checkli comparison lays out where each one pulls ahead.

Verdict: a Google Sheets checklist tracker is the fastest free way to turn a Triptyka printable passport into a live, sortable progress tool in 2026 — build it once and reuse the template for every new checklist you buy.

FAQ

One last thing

The single most useful cell in the whole sheet isn't the checkbox column — it's the percentage formula. Collectors who build a tracker in 2026 and skip that one formula tend to abandon the sheet within a month, because there's no visible payoff for checking a box. The percentage is what makes checking off item 40 of 63 feel like progress instead of data entry.

Related guides

• Best bucket-list printables and trackers for travel lovers
• Best national park checklist trackers
• How to import your printable checklist into GoodNotes