Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

checkbox

I have a question about the checkbox. I have a Sheet "Tasks" and Sheet "Overview”. Would be possible get active tasks in overview table? I have tried with IF(A2="TRUE";ROW(A2);9999) way, but do not work with the checkbox system.

Thanks

User uploaded file

User uploaded file

Mac mini, iOS 11.4.1

Posted on Nov 5, 2018 5:28 AM

Reply
Question marked as Best answer

Try this:


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

User uploaded file

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.

User uploaded file


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

Posted on Nov 5, 2018 8:34 PM

7 replies

Nov 5, 2018 6:06 AM in response to ryszardb

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:



User uploaded file


User uploaded file


Method 2. Use Categories.


User uploaded file


User uploaded file


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


SG

Question marked as Best answer

Nov 5, 2018 8:34 PM in response to ryszardb

Try this:


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

User uploaded file

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.

User uploaded file


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

checkbox

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.