A service-job spreadsheet can look complete while still leaving someone unsure what to do next. This tutorial creates a visible exception queue for missing next actions: review each active job, label unclear entries, highlight those labels, and pull the flagged jobs into a compact list. The missing-action judgment remains manual; the formatting and filtered output respond to your labels. Use this approach when you want a straightforward review routine rather than automatic deadline detection.
Set up a small missing-action review area
For this suggested layout, use column A for the client or job, column B for the next action, and column C for a review label. Put headers above the data. For the small example below, use A2:C5 as the job range. Keep the next action specific enough that another person could understand the intended task without reconstructing the conversation.
Review the active jobs and enter Needs action in column C wherever the next action is blank or too vague to execute. A note such as “pending” may describe the situation without identifying a task. Treat this label as an instruction to clarify the record, not necessarily to contact the client immediately. Leave unused rows unlabeled.
Highlight the labels with conditional formatting
On a computer, open the spreadsheet and select C2:C5. Click Format, then Conditional formatting. Create a Single color rule. Under Format cells if, choose Text contains and enter Needs action. Under Formatting style, choose a noticeable background color, then click Done. Google Sheets can change cell formatting when the contents meet a condition; this rule makes the review labels stand out. [1]
Keep the written label even though the color attracts attention. As a workflow suggestion, reserve this highlight for missing or unclear actions rather than using it for every important job. Otherwise, the distinction between “this job matters” and “this record needs repair” becomes harder to see.
Create a filtered queue of flagged jobs
In an empty area away from the source records, enter =FILTER(A2:C5,C2:C5="Needs action"). This applies FILTER to the job range using a matching review-label condition. FILTER returns rows or columns that satisfy its conditions, so the resulting queue includes the flagged records with their next-action field and review label. Keep space around the output for the returned records. [2]
When adapting the example to your working sheet, extend the source range and condition range together. FILTER requires each condition to have the same length as the range being filtered. Keep this queue row-based; the function does not allow row conditions and column conditions to be mixed. If no records meet the condition, FILTER returns #N/A, which can mean there are no matching labels rather than a broken review process. [2]
Resolve the exception in the source record
Hypothetical example: a cleaning business has a job whose next-action field says “waiting.” During review, the coordinator adds Needs action because the intended task is unclear. After checking the job notes, they replace “waiting” with “Ask the property manager to confirm access arrangements” in the source record and remove the review label. The purpose is to repair the instruction, not merely clear the highlight.
Avoid misleading results and finish with a checklist
Common mistakes include inconsistent review labels, forgotten range extensions, and conflicting formatting. Conditional-formatting rules are evaluated in their listed order, with the first true rule determining the format. Copying and pasting cells that contain formatting rules also carries those rules into the destination. If the highlight looks wrong, inspect existing rules before adding another. [1]
Use this short checklist at each review: inspect active jobs for missing or vague next actions; apply the agreed label consistently; check that the queue covers the intended records; rewrite unclear instructions in the source; and remove labels only after the action is usable. Remember that an unlabeled omission will not appear in this queue.
Sources
- Use conditional formatting rules in Google Sheets – Computer – Google Docs Editors Help
- FILTER function – Google Docs Editors Help
Prepared with AI assistance from the linked documentation, checked on 2026-09-19. Examples are suggested workflows, not claims of hands-on product testing.