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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • 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.