4 Replies Latest reply: Aug 30, 2013 4:13 PM by ShootnHooton
Kunardi Level 1 Level 1

I´m making a spreadsheet where is multiple values and I´d like to use a checkbox to activate/deactivate some cells. Is it possible in Numbers and how or should I try it in other way? The spreadsheet is going to customer and it is easiest way to choose what they want just only marking the right checkbox.


Numbers 1.0.3, OS X Mountain Lion (10.8.2)
  • Wayne Contello Level 6 Level 6
    expertise.iwork
    iWork

    It is not possible to activate/deactivate interface features using other features in Numbers.  You could add a single column that attempts to guide a user as to what boxes to check and flag error.  You could also group selections such that previous selections "tell" the user what group to select next.

     

    Without seeing an actual example of what you want to do it is hard to comment specifically but it sound like if there are more than a few selections the logic could become a mess quickly.

     

    Post an example screenshot and that may get some ideas started.

  • Kunardi Level 1 Level 1

    Kuvankaappaus 2013-1-21 kello 16.17.16.jpg

     

    The columns are item and price. So if customer want to buy that item, she only activate the checkbox. And the final price will only be the checked items. That is what I want, the easiest way.

  • Wayne Contello Level 6 Level 6
    expertise.iwork
    iWork

    You can use the sumif() function like:

    Screen Shot 2013-01-21 at 9.42.37 AM.png

    Set the first row to be a header and the add a footer row:

     

    to sum item prices where a checkbox is checked use the formula:

    C10=SUMIF(A, TRUE, C)

     

    I hope this helps

  • ShootnHooton Level 1 Level 1

    Thanks Wayne,

     

    That's exactly what I wanted to know how to do in order to activate/deactivate rows, and consequently the sums of my columns.