What's new
Every guide and tool added or updated, newest first. Last change . Guides carry their own published and updated dates too. For what is planned next, see Coming up.
7 changes
- SiteComing up page added: the guides and tools planned for the next three months, why each is on the list, and the price re-checks due.
- SiteGmail search builder added: fill in plain fields and get the search to paste into Gmail, using only operators on Google's own list.
- SiteGuides that mention a price or plan now say when those details were checked and when they will be checked next. Every check is at most three months apart, and the site will not build if one is overdue.
- SiteSubmit software for review: suggest a product for the upcoming software finder. Free, read by Nick, and never paid for.
- SiteThe worksheets on the home page, in guides and on the completion rate tool now take your own data: change any shaded cell, add or remove rows, or paste rows from a spreadsheet.
- UpdatedNormalize CRM Email Addresses Before a CSV Import Google Sheets, formula
- UpdatedSet Up a Recurring Weekly Check-In Reminder in Slack Slack, template
11 changes
- Site14 browser calculators added to the toolbox: timesheets, working days, meeting cost, list cleanup and more.
- SiteGoogle Sheets workday formula builder added.
- SitePlain-English SQL query builder added: fill in a sentence and get the query for MySQL, PostgreSQL or DuckDB, tested on all three.
- SiteSQL guides now cover MySQL and PostgreSQL as well as DuckDB. They are so deeply part of what we all do that every query is now run on all three, with a separate version wherever the syntax differs.
- SiteTopic pages rewritten: what each topic covers, where it goes wrong, and every guide grouped by job.
- UpdatedCalculate a Dashboard Completion Rate Without Averaging Percentages SQL, query
- UpdatedFill Missing Days with Zero in a SQL Task-Completion Report SQL, query
- UpdatedFind Projects with No Tasks Using a SQL LEFT JOIN SQL, query
- UpdatedKeep the Latest Status Row per Task with SQL ROW_NUMBER SQL, query
- New guideFind Files Shared with Anyone with the Link in Google Drive Google Drive, script
- New guideSet Up a Recurring Weekly Check-In Reminder in Slack Slack, template
2 changes
- New guideCalculate Days Until Due and Flag Overdue Tasks in Notion Notion, formula
- New guideLabel and Archive Old Newsletters in Gmail with Apps Script Gmail, script
3 changes
- New guideCreate a Follow-Up Task When a HubSpot Deal Sits in One Stage Too Long HubSpot, template
- New guideList Every File in a Google Drive Folder to a Sheet with Apps Script Google Drive, script
- New guideSend New Google Form Responses to a Slack Channel Slack, script
3 changes
- New guideFind Duplicate Companies by Domain Before a HubSpot Import HubSpot, formula
- New guideHighlight Overdue Tasks in an Excel Tracker with Conditional Formatting Excel, formula
- New guideShow Project Progress from Related Tasks in Notion with a Rollup Notion, template
3 changes
- New guideCount Open Tasks by Owner with Google Sheets QUERY Google Sheets, formula
- New guideFind Large Attachments and Old Mail with Gmail Search Operators Gmail, query
- New guideFind Same-Name Files in a Google Drive Folder Without Deleting Anything Google Drive, script
3 changes
- New guideCount Workdays and Set Due Dates in Google Sheets with Holidays Google Sheets, formula
- New guideKeep the Latest Status Row per Task with SQL ROW_NUMBER SQL, query
- New guideSum Only Visible Task Counts After Filtering in Excel Excel, formula
4 changes
- SiteGoogle Sheets currency formula builder added.
- New guideBuild a Dynamic FX Calculator in Google Sheets with GOOGLEFINANCE Google Sheets, formula
- New guideCalculate a Dashboard Completion Rate Without Averaging Percentages SQL, query
- New guideClean a Contact Spreadsheet for a HubSpot CSV Import HubSpot, formula
2 changes
- New guideConvert UTC Handoff Times to Local Time in Google Sheets Google Sheets, script
- New guideSend One Daily Task Reminder from Google Sheets Without Repeat Emails Google Sheets, script
2 changes
- New guideFind Projects with No Tasks Using a SQL LEFT JOIN SQL, query
- New guideFlag CRM Contacts Missing an Owner or Next Step Google Sheets, formula
2 changes
- New guideAutomate a Weekly Report Page in Notion for Remote Teams Notion, script
- New guideFind Open CRM Contacts with No Recent Follow-Up Google Sheets, formula
3 changes
- New guideLook Up a Project Owner by ID in Excel Without Approximate Matches Excel, formula
- New guideRename Invoice PDFs in Google Drive from a Tracking Sheet Google Sheets, script
- New guideShow Only Blocked Tasks in a Google Sheets Project Tracker Google Sheets, formula
3 changes
- New guideExport CRM Notes to CSV Without Breaking Commas or Line Breaks Google Sheets, script
- New guideSync Google Sheets Task Deadlines to a Google Calendar Google Sheets, script
- New guideUnpivot a Small Monthly Table in Google Sheets Without Add-ons Google Sheets, formula
7 changes
- SiteSite launched with the first guides and five tools: completion rate, handoff time, contact cleaner, Sheets QUERY builder and latest-row SQL builder.
- New guideCreate Gmail Reply Drafts from Google Forms Responses Gmail, script
- New guideFill Missing Days with Zero in a SQL Task-Completion Report SQL, query
- New guideNormalize CRM Email Addresses Before a CSV Import Google Sheets, formula
- New guidePost a Daily Blocked-Tasks Summary from Google Sheets to Slack Slack, script
- New guideSet Up an Async Decision Log with an Explicit Response Deadline Google Sheets, template
- New guideTurn Google Sheets Status Updates into an Async Weekly Digest Google Sheets, script