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

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.

  • 1. Re: checkist to create a list
    Wayne Contello Level 6 Level 6 (13,615 points)

    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