1 Reply Latest reply: Nov 14, 2012 3:32 PM by Wayne Contello
Concreate Level 1 Level 1

i want to use a checklist of say 20 items and if the user checks 8 of them, another checklist of just the selected items is created on another page.

  • Wayne Contello Level 6 Level 6

    This may work for you:


    Assuming you have a table like:

    Screen Shot 2012-11-14 at 5.31.07 PM.png

    This table is called "Base Task List".  I added a column (column D) for an aux column (which you can hide).

    D2=IF(C2, A2, "")

    select D2 and fill down



    In a second table:

    Screen Shot 2012-11-14 at 5.31.19 PM.png


    In the table on the right:

    A2=IFERROR(SMALL(Base Task List :: D, ROW()-1), "")

    B2=IFERROR(VLOOKUP(A2, Base Task List :: $A:$B, 2, 0), "")


    select A2 and B2, then fill down


    in both tables the first row is a header