Automatically hide rows

Hmm…

Tried a possible solution, but ran into a roadblock. Applying an active filter to the table prevented inserting a row below the last visible row without first turning the filter off.

Here's the example, showing both auxiliary columns (F and G) controlling what rows will be displayed when the table is filtered.

F2 contains the formula ROW() which returns the row number of the row containing each copy.

G2 contains this formula ROW()>MAX(F)−2

Both formulas are filled down to the last non-footer row in the table, and are automatically copied into a new row when one is inserted.

To insert a new row, click on a cell in the last body row (containing the most recent entry) then either press return or press option-down arrow to insert a new body row (shown above).

Columns F and G would ve hidden in normal use, giving this appearance to the unfiltered table…

And this appearance after the following steps:

• Select a cell in the last entry.
• Open the Sort and Filter Inspector to Filter.
• Click the Filter checkbox to uncheck it.
• Press return to confirm the entry in the selected cell, insert a new row and move the focus to the cell in the same column of that new row.
• Click the Filter checkbox to re-activate the filter.

Not a pretty solution, but the best I can see for now, given the apparent prohibition on inserting new rows to a filtered table.

Regards,

Barry

I do not recall the previous effort. And to be clear, we are not "support people" we are other users of the app.

Because of the inability to add rows to filtered tables, I think you'll have to start out with a large table, only one row of which you will see at any given time. Each row will have a checkbox. When you click the checkbox, the row will hide and the next empty row will show.

First screenshot is an example table with the filter off.

Second is the same table with the filter on. Row 6 is the only row showing.

Third is the same table after checking the box in row 6. Now row 7 is showing

Your table would be much longer than the one in my example I would think.

The formula in cell G2 =AND(C2=FALSE,C1≠FALSE)

Fill down to complete the column

Hide column G after it is set up.

Turn off the filter to see all the rows again.

"Looking at this…" raises these questions.

Why is there a "41" in row 31 of the Date column?

The heavier cell boundary between rows 31 and 32 suggests that rows 32, 33 and 34 are Footer rows. Is this correct? Should row 31 also be a Footer row?

Regards,

Barry

I am confused as to what you want to hide and what it means to "create a new entry".

Does "create a new entry" mean "add a new row to the table" or does it mean "enter data in the next empty row" or something else?

Does "hide the last previous row entered" mean "hide the row directly above the new one you just added" or does it mean "hide all the rows above new row just added" or does it means something else.

Do you expect the "previous previous row" to unhide when the "previous row entered" becomes hidden or is it once hidden, always hidden?