Skip to content

Guides by software

Pick the product you're working in.

Google Sheets
SQL
Excel
Notion
Slack
HubSpot
Gmail
Google Drive

Google Sheets

Google Sheets guides
Row	Problem	Tool	You get a
	Convert UTC Handoff Times to Local Time in Google Sheets	Google Sheets	Script
	Count Open Tasks by Owner with Google Sheets QUERY	Google Sheets	Formula
	Export CRM Notes to CSV Without Breaking Commas or Line Breaks	Google Sheets	Script
	Find Open CRM Contacts with No Recent Follow-Up	Google Sheets	Formula
	Flag CRM Contacts Missing an Owner or Next Step	Google Sheets	Formula
	Normalize CRM Email Addresses Before a CSV Import	Google Sheets	Formula
	Rename Invoice PDFs in Google Drive from a Tracking Sheet	Google Sheets	Script
	Send One Daily Task Reminder from Google Sheets Without Repeat Emails	Google Sheets	Script
	Set Up an Async Decision Log with an Explicit Response Deadline	Google Sheets	Template
	Show Only Blocked Tasks in a Google Sheets Project Tracker	Google Sheets	Formula
	Sync Google Sheets Task Deadlines to a Google Calendar	Google Sheets	Script
	Turn Google Sheets Status Updates into an Async Weekly Digest	Google Sheets	Script
	Unpivot a Small Monthly Table in Google Sheets Without Add-ons	Google Sheets	Formula

SQL

SQL guides
Row	Problem	Tool	You get a
	Calculate a Dashboard Completion Rate Without Averaging Percentages	SQL	Query
	Fill Missing Days with Zero in a SQL Task-Completion Report	SQL	Query
	Find Projects with No Tasks Using a SQL LEFT JOIN	SQL	Query
	Keep the Latest Status Row per Task with SQL ROW_NUMBER	SQL	Query

Excel

Excel guides
Row	Problem	Tool	You get a
	Look Up a Project Owner by ID in Excel Without Approximate Matches	Excel	Formula
	Sum Only Visible Task Counts After Filtering in Excel	Excel	Formula

Notion

Notion guides
Row	Problem	Tool	You get a
	Automate a Weekly Report Page in Notion for Remote Teams	Notion	Script

Slack

Slack guides
Row	Problem	Tool	You get a
	Post a Daily Blocked-Tasks Summary from Google Sheets to Slack	Slack	Script

HubSpot

HubSpot guides
Row	Problem	Tool	You get a
	Clean a Contact Spreadsheet for a HubSpot CSV Import	HubSpot	Formula

Gmail

Gmail guides
Row	Problem	Tool	You get a
	Create Gmail Reply Drafts from Google Forms Responses	Gmail	Script

Google Drive

Google Drive guides
Row	Problem	Tool	You get a
	Find Same-Name Files in a Google Drive Folder Without Deleting Anything	Google Drive	Script