Skip navigation

checkist to create a list

191 Views 1 Reply Latest reply: Nov 14, 2012 3:32 PM by Wayne Contello RSS
Concreate Calculating status...
Currently Being Moderated
Nov 14, 2012 2:07 PM

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 (12,665 points)
    Currently Being Moderated
    Nov 14, 2012 3:32 PM (in response to Concreate)

    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


More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.