Auto populate another sheet when checkbox checked

If you really just need a list with the items that you have checked I would not use a complicated formula.

Here a very easy solution.

Create 2 tables, table 1 has the list and the check marks. Table 2 is the output list.

In every cell of table 2 you have a simple IF formula. If the check mark is set then write the text, if not write ##

Then you create a filter for table 2.

Filter will only display text that is NOT ##

As soon as the filter is activated you have your short list.

Please let me know if I have missed something and did not get what you really wanted.

Ralf

Those complicated formula-based approaches probably predate the addition of the Filters functionality to Numbers several years ago.

To do this kind of thing these days you no longer need ANY formula. Just a few clicks and you're done!

It's often better to just leave your data in one place. But if you really need to duplicate the results into another table, just have another table ready, then select the visible cells in the filtered table, command-c to copy, click once in the cell of the destination table, and command-v to paste.

SG

Hi James,

Here's another solution, even easier than Ralf's ;^)

You need only one table, set up as shown above—column A lists an number of tasks (or of grocery items). Column B contains a checkbox for each item.

Here, my 'items' are 14 recurring tasks, five of which need to be done at this time.

With the tale set up, I went to the Organize menu,and chose Show Filter Options.

This menu item pesents several options for setting up a filter to show only a selected set of the rows in the table, plus the Header row, which is always visible.

In the right sidebar, I set this filter, acting on the contents of Column B:

By default, all filters are "On" when created, so, when I was done, the filter had acted to show only the Header row and the rows where the checkoxes were checked in column B.

This filtered table could then be viewed as filtered, or could be captured as an image by taking a screen shot, then printing it or sending it you yourself in an email, or copying/transmitting it to a portable device to take with you as you completed the tasks.

To see the whole list, Click the table to activate it, Click the Organize button to open the Inspector in the right sidebar, then click the Filter switch to turn Filters off.

Regards,

Barry

Keep in mind that if you use Quick Filter as I illustrated above, all you have to do is got the column letter, in this example column A, and choose Quick Filter from the dropdown and uncheck FALSE, as shown.

Done in a second or so.

No need for formulas. And no need to go to the panel at the right, except in cases where you might need a more complex filter.

SG

Hello James,

could you please post a screenshot of your formula in cell A1 of the second chart "Equipment required "?

I have the feeling that it is not right.

Ralf

@ SGIII

Agreed.

I'd opened and begun my post above before heading off to other things, and completed it without having looked back at the thread some time later.

Saw your 'quick filter' post still later, and agree that it's a simpler solution, hence this reply.

Regards,

Barry