My Day✳All blog articles ↗

Check the filter scope before declaring a list complete

Inspect the full stated table rather than only its visible completed rows.

Excel filters hide rows that do not meet the condition. A “done” view cannot therefore prove there are no open items. Record the viewing condition, then inspect the whole stated table. This does not establish the state of every project.

2 visible rows; 3 total rows; 1 open row
2 visible rows; 3 total rows; 1 open row

What to do

  1. Establish the table's boundary and note its active filter.
  2. Clear the specified filter to reveal that table's complete set.
  3. Check excluded rows' states and state the scope of your conclusion.

Example

Fictional table: T1 is done, T2 done, T3 open. Filtering “done” displays 2 rows. Clearing it reveals all 3, including 1 open row. Record “T3 remains open in this table.” No row was recreated. The filter is an Excel feature, not an asserted My Day feature.

My Day · Windows

Manually save this personal record in My Day.

Buy My Day for Windows ↗