Tools

Free, no sign-up. Build the formula or the rule, copy it, get on with your day. Nothing here calls a model — each one composes its answer the same way every time, and tells you what usually goes wrong with it.

• Google Sheets QUERY builder

  Select, filter, group and sort — with the clause order, the column references and the value quoting all handled. Explains what it built and warns about the things that usually go wrong.

• Conditional formatting formula builder

  Highlight a whole row, flag duplicates, colour overdue dates. Writes the custom formula against the first cell of your range and anchors it the way the rule needs, which is the part that catches people out.

• Google Forms response validation builder

  Phone numbers, reference codes, one domain of email addresses. Gives you the pattern and the operation to pair it with — get that second dropdown wrong and the rule quietly stops rejecting anything.

• Auto-timestamp script builder

  The Apps Script that stamps the time when a cell changes — with your own columns in it, not the blog post's. Last-updated or created-at, one tab or all of them, and a table of what it does edit by edit.

• Google Forms branching planner

  Go to section based on answer, checked before you build it. Walks every answer's path the way Forms routes a respondent and catches the section that falls through into the wrong audience — the defect the editor never shows.