checkbox

There are ways to do that with an extra column and some somewhat complicated formula.

But why not take advantage of the built functionality in Numbers. No formulas, no extra columns. Done in a few sections.

Method 1. Apply a filter:

Method 2. Use Categories.

Then go to Organize > Turn Categories Off when you're done.

SG

ryszardb wrote:

I use "Overzichten" to see totals

But you can easily calculate subtotals or counts using the Categories feature. Just a few clicks in a few seconds. No need for separate table on a separate sheet.

SG

Try this:

Add a column to the data table to accomodate an index of the rows containing active tasks:

The index is created by the formula shown below the table, entered in C2 and filled down to the end of column C.

On the Active tasks table, the formula shown below uses the index numbers to retrieve the task names from column B of the Tasks table.

The formula is entered in A2 of ActiveTasks, and filled to the end of that column.

IF(ROW()−1>MAX(Tasks::C),"",INDEX(Tasks::B,MATCH(ROW()−1,Tasks::C,0)))

The part in bold does the heavy lifting. The rest is a switch that prevents the INDEX part from looking for additional tasks when the last has been retrieved.

Regards,

Barry

Hi Ryszard,

You can filter the Tasks table.

To see all Tasks, turn the filter off

Regards,

Ian.