Auto populate another sheet when checkbox checked

""Index" is in F9

Formula is in F10"

Then the formula in F10 should be:IF(C10,MAX(F$:F9)+1,"")

And NO cell in the range F1:F9 can contain a number.

What is currently in rows 1 to 8? Could than data be placed in a table separate from the checklist?

A screenshot showing A1 to F16, with F10 selected, and at least one unchecked box would be useful.

Regards,

Barry

Here's one way.

It uses two formulas, one to create an Index column on Table 1 (the checklist), the other to capture the checked items and copy then to Table 2 (the To Do table).

The formula shown in entered in C2 of the checklist table, and filled down to the end of the column. C1 may be left empty, or may contain a text value (which MAX will read as 'zero')

In use, column C is needed by Numbers, but the user has no need to see it, son the column may be hidden, as it is below:

The formula below the table is entered in A2, then filled down to the last row of column A.

IF first checks the index column (C) of table 1 to determine if all checked items have been transferred.

If so, it places a null string in the cell, making it appear empty.

If not, MATCH searches Column C of Table 1 for the number one less than the current row, and returns the row number of the row containing that index number in the list in column C.

MATCH passes the position number to INDEX, which returns the value in that row of column A.

NOTE: When you create a new Sheet on which to place the ToDo list, the Sheet will come with a Table, named Table 1.

This will cause no issues with the first formula, which references only cells on its own table.

But the second formula references cells on Table 1 (on Sheet 1). Renaming one or both tables so that each has a distinct name let's Numbers recognize which table is the one containing the cells in column A and Column C without requiring the Sheet name o be included. Do the renaming before entering the formulas, then use the name of the checklist table where I have used "Table 1"

Regards,

Barry

Hi sakindona,

Is the text "Index" In cell F1?

My tables assume that Table 1 contains one Header row (Row 1), and that the labels are in that row. Your table appears to have at least one row above the cell containing the text "Index", which may be part of the problem.

What is the address (column and row) of the cell containing "Index"?

What is the address (column and row) of the first cell containing the first formula?

Regards,

Barry

Why not take advantage of built-in filtering capabilities in Numbers? Filter on the checked column, select visible cells, command-c to copy, click in a cell of the separate table, and command-v or Edit > Paste and Match style. Done in a few seconds. No formulas. Even if you have to update often, this is very efficient.

SG