rbrocky

Q: No SHEETOFFSET option in numbers?

So I have noticed that there is no sheetoffset option with numbers (iOS) like there is with excel.

 

I am trying to refer to a previous -1 sheet, which is no problem.

 

so when on sheet B I can refer to sheet A, now if I copy this formula to say sheet C, the formula will still refer to sheet A when I would like it to refer to sheet B and sheet D to sheet C (and so on). It's easy enough to change the formula. But I am planning on using this as an accumulative spreadsheet and each sheet meant for a week. So ideally an automatic solution would be ideal.

 

Could anyone help?

 

Thanks

 

Ps, I am actually running an iPhone 5 on 7.1, please ignore the footnote!

iPhone 5, iOS 7.1, null

Posted on Sep 6, 2015 2:28 AM

Close

Q: No SHEETOFFSET option in numbers?

  • All replies
  • Helpful answers

  • by t quinn,

    t quinn t quinn Sep 6, 2015 6:31 AM in response to rbrocky
    Level 5 (5,058 points)
    Mac OS X
    Sep 6, 2015 6:31 AM in response to rbrocky

    Hi rbrocky,

     

    How are you naming your tables? If they have unique names "Week 1" etc. you could have a cell in your table to hold that value and use it to find the previous table. With unique table names you don't need to specify a sheet.

    Screen Shot 2015-09-06 at 7.25.56 AM.png

    I am told that INDIRECT() recalculates whenever anything changes in a table. It may slow thing down on your 5. When I was using an iPod Touch 5g I reorganized my tables to avoid taxing the hardware.

     

    quinn