Producfy

Working formulas, queries and scripts for the software your team already uses.

SELECT team, SUM(completed_tasks) * 1.0 / NULLIF(SUM(total_tasks), 0) AS completion_rate FROM project_counts GROUP BY team;

Each guide solves one narrow problem and shows the sample data, so you can compare your result with ours before you trust it.

ProblemToolYou get a
Automate a Weekly Report Page in Notion for Remote TeamsNotionScript
Calculate a Dashboard Completion Rate Without Averaging PercentagesSQLQuery
Clean a Contact Spreadsheet for a HubSpot CSV ImportHubSpotFormula
Convert UTC Handoff Times to Local Time in Google SheetsGoogle SheetsScript
Count Open Tasks by Owner with Google Sheets QUERYGoogle SheetsFormula
Create Gmail Reply Drafts from Google Forms ResponsesGmailScript
Export CRM Notes to CSV Without Breaking Commas or Line BreaksGoogle SheetsScript
Fill Missing Days with Zero in a SQL Task-Completion ReportSQLQuery
Find Open CRM Contacts with No Recent Follow-UpGoogle SheetsFormula
Find Projects with No Tasks Using a SQL LEFT JOINSQLQuery
Find Same-Name Files in a Google Drive Folder Without Deleting AnythingGoogle DriveScript
Flag CRM Contacts Missing an Owner or Next StepGoogle SheetsFormula
Keep the Latest Status Row per Task with SQL ROW_NUMBERSQLQuery
Look Up a Project Owner by ID in Excel Without Approximate MatchesExcelFormula
Normalize CRM Email Addresses Before a CSV ImportGoogle SheetsFormula
Post a Daily Blocked-Tasks Summary from Google Sheets to SlackSlackScript
Rename Invoice PDFs in Google Drive from a Tracking SheetGoogle SheetsScript
Send One Daily Task Reminder from Google Sheets Without Repeat EmailsGoogle SheetsScript
Set Up an Async Decision Log with an Explicit Response DeadlineGoogle SheetsTemplate
Show Only Blocked Tasks in a Google Sheets Project TrackerGoogle SheetsFormula
Sum Only Visible Task Counts After Filtering in ExcelExcelFormula
Sync Google Sheets Task Deadlines to a Google CalendarGoogle SheetsScript
Turn Google Sheets Status Updates into an Async Weekly DigestGoogle SheetsScript
Unpivot a Small Monthly Table in Google Sheets Without Add-onsGoogle SheetsFormula