No SHEETOFFSET option in numbers?

Question

Level 1

8 points

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:24 AM

Reply

Answer 1

t quinn

Level 5

7,063 points

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.

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

Reply