WORKFLOWFIX LAB / ARTICLES

Guides & research notes.

Practical, source-based instructions for AI tools, software troubleshooting and spreadsheets.

Excel & Google Sheets · November 5, 2026

Why Your COUNTIF Formula Keeps Returning 0 (And the Embarrassingly Simple Fix)

You can count completed tasks in Google Sheets with the COUNTIF function. If your task statuses are in cells B2 through B5, enter the following formula in an empty cell: =COUNTIF(B2:B5,"Completed") The formula counts how many cells contain the status “Completed.” In our simple test using four sample tasks, it returned 3, matching the three […]

Read Article →

AI Tools · November 5, 2026

How I Automated My 3-Hour Weekly Report into 5 Minutes Without Writing Code

AI productivity tools can help office workers draft emails, organize meeting notes, analyze spreadsheet information, and plan repetitive tasks. The most effective approach is to use AI for clearly defined tasks while keeping a human responsible for checking the results. You do not need to automate an entire department to see where AI might be […]

Read Article →