Apple Numbers for the ipad

Discussion in 'iPad Help' started by Adam Huffman, Apr 19, 2012.

  1. Adam Huffman
    Offline

    Adam Huffman iPF Noob

    Joined:
    Apr 19, 2012
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Have a formula that I can't figure out. Please help me.

    How have many tabs in one workbook. I can't figure this formula out.

    I have a multiple choice cell on one page that I would like to change another multiple choice cell on another page.

    Example: if this option in this cell is chosen in this box on this page then on this other page in this multiple choice cell this needs to be this other option etc....
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,236
    Thanks Received:
    1,964
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,185 / 1
    I'm quite sure what you are describing.

    If it is a matter of selecting cells in another tab, just make sure the variable is highlighted (dark blue), then navigate to the right tab and table, then select the cell.

    As long as you are careful not to tap any other cells along the way it will work fine.
  3. Adam Huffman
    Offline

    Adam Huffman iPF Noob

    Joined:
    Apr 19, 2012
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Yes I can do that, but what I can't figure out is how to get the first multiple choice answer to automatically chose a particular multiple choice answer in another cell on a different tab (or page).
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,236
    Thanks Received:
    1,964
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,185 / 1
    If I understand what you are trying to do, I'm pretty sure you can't. Multiple choice is a cell format, not a formula. There is no way to modify a cells format except to edit it manually. You'd need some kind of scripting ability, and the iOS version of Numbers does not support scripts.

Share This Page