U.S. + CANADA · TRADEMARK DOCKET TRACKER
The One-Click Trio™ 2.0 is a Google Sheet that automatically calculates every key USPTO and CIPO deadline the moment you enter an issuance date, so you can stop doing the math and start staying ahead.
One-time · $97 · Google Sheets
SOUND FAMILAR?
Every time a new Office Action comes in, you're doing the same calculations - 3 months from this date, extension by that date, CIPO deadline on the other. One wrong date and the whole matter is at risk.
You're manually calculating USPTO and CIPO deadlines every time a new Office Action comes in
Your deadline tracking is spread across multiple spreadsheets, sticky notes, or calendar reminders
You handle both U.S. and Canadian matters, but have no single place to track both jurisdictions
You're spending time on deadline math that should be automated so you can focus on the actual work
WHAT IT DOES
Enter the Office Action issuance date or CIPO Examiner's Report date, and the tracker automatically populates every key deadline: 3-month response, 6-month response, extension deadlines, and more. No formulas to write. No math to do.
Color-coded columns show you at a glance which matters are on track and which are approaching a critical date — so nothing slips through.
WHAT'S INSIDE
Six tabs covering every scenario - auto-calculated and manual, U.S. and Canada.
Enter the issuance date — 3-month deadline, 30-day reminder, and extension dates populate automatically. No math needed.
Enter the CIPO Examiner's Report date - 6-month deadline and 30-day reminder calculate instantly. Extension date generates only when status is marked Granted.
Prefer full control? Enter every date yourself. Same clean layout, no auto-formulas - works exactly the way you want it to.
Manual mode for Canadian matters. All the organization, none of the auto-formulas.
Built-in conditional formatting shows you at a glance which matters are on track and which need immediate attention.
Video #1: Spreadsheet overview · Video #2: Add a calendar in a cell · Video #3: Edit & create dropdowns Video #4: Conditional formatting walkthrough.
All U.S. and Canada formula codes are documented so you know exactly what each one does, and what not to touch.
OA, OAR, EA, NOA, SOU - every trademark docketing abbreviation is defined so your whole team is working from the same language.
WHAT'S NEW IN VERSION 2.0
Here's what changed from version 1 to 2.0.
Added Canada sheet for CIPO Examiner's Report tracking
6-month response calculation for Canadian Office Actions
Notes section for opposition deadlines
Refreshed layout for faster date visibility
Customization functions - dropdowns and settings to adjust colors and labels
★★★★★
"Melody brings her expertise effortlessly into her products and knows exactly what you need in your firm to ease your backend."
No, the One-Click Trio™ 2.0 works in Google Sheets. You just need a free Google account to access and use it.
Absolutely. Just use the U.S. tabs and ignore the Canada ones. The tracker works just as well for U.S.-only practices.
Yes, you can rename columns, adjust dropdowns, and add your own color rules to fit your firm's workflow. Just be careful editing the formula cells since changing them may affect how dates are calculated automatically.
No, email templates are sold separately. The SAPR Trademark Email Vault pairs well with this tracker if you want client communication covered alongside your deadline tracking.
Yes! You can rename columns, adjust dropdowns, and add your own color rules to fit your firm’s workflow.
This tracker has built-in formulas that calculate key deadlines; edit at your own risk, since changing them may affect how dates fill in.
Version 2.0 added Canada tracking for CIPO Examiner's Reports, manual entry tabs for both jurisdictions, enhanced U.S. deadline formulas, and a refreshed layout for faster date visibility.
ONE-CLICK TRIO™ 2.0
$97
One-time payment · Google Sheets
U.S. Auto Tracker: deadlines calculate automatically
U.S. Manual Tracker: full manual control
Canada Auto Tracker: CIPO 6-month deadlines
Canada Manual Tracker: manual mode
Color-coded conditional formatting throughout
4 firm use walkthrough videos
Formula codes reference for U.S. + Canada
Terms glossary: OA, OAR, EA, NOA, SOU
WHILE YOU'RE AT IT, FRIEND!
The Trademark Docketing Cheat Sheet is a one-page quick reference covering every key USPTO timeframe - so you can double-check critical dates at a glance without opening a dozen tabs.
Daily. Desk. Essential.
EXPLORE THE SHOP
Beyond the Vault, Legal Oats has everything your practice needs, from copyright templates to SOPs, intake forms to marketing tools.
You've made it to the bottom - find exactly what you need up top.