Logical
Check if a row is completely blank, complete, or partially filled
Classify rows as blank, Complete or Incomplete with COUNTBLANK and COLUMNS.
Three distinct row states: Empty, Complete, and Incomplete
ISBLANK(A2:D2) tests individual cells rather than summarizing an entire intake row, and COUNTA(A2:D2)=0 gets fooled by formulas returning "".
COUNTBLANK counts genuinely empty cells and formula results equal to the empty string. This example returns an empty label for an entirely blank row, Complete for zero blanks, and Incomplete otherwise.
| Name (A) | Email (B) | Dept (C) | Role (D) | Row Status |
|---|---|---|---|---|
| Elena | e@co.com | Eng | Lead | Complete (0 blanks) |
| Marcus | m@co.com | (blank) | PM | Incomplete (1 blank) |
| (blank) | (blank) | (blank) | (blank) | Blank Row (4 blanks) |
3-state form completeness audit formula
Bind b = COUNTBLANK(A2:D2) with LET so the range is scanned once.
=LET(b, COUNTBLANK(A2:D2), IF(b=COLUMNS(A2:D2), "", IF(b=0, "Complete", "Incomplete")))Boolean test: entire row or block is completely blank
Multiply ROWS(r) * COLUMNS(r) when testing a multi-row 2D block instead of a single row.
=COUNTBLANK(A4:D4) = COLUMNS(A4:D4)Inputs and interpretation
Spaces, error values and zero are not blank. A Complete label means every field is populated, not that its content is valid. Validate emails, required types and other business rules separately.
Try the example
Use the original values or change them to test your understanding.