My Day✳All blog articles ↗

Separate zero, unknown and not applicable

An empty cell does not establish that no attachments exist.

A checked zero, missing information and an inapplicable field answer different questions. Define a clear local legend before completing a work checklist. Replacing an unknown count with zero makes unfinished verification look complete and can distort a later total.

1 folder in each state: checked zero, unknown count, not applicable
1 folder in each state: checked zero, unknown count, not applicable

What to do

  1. Check whether attachments are required for each folder under the agreed contents list.
  2. Where they are required, count them; label an unchecked count “unknown” instead of guessing.
  3. Keep the legend beside the table and record a separate action to resolve the remaining unknown.

Example

Fictional example: folder A was checked and has 0 attachments; B is unchecked; C does not require attachments. There is 1 folder in each state. Write “A: 0; B: unknown; C: not applicable.” Counting B remains an open action.

My Day · Windows

My Day can hold the legend in a task note that you save and update manually.

Buy My Day for Windows ↗