Benches Uncategorized

2

Duplicate sheets messes up nested formulas?

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I have a formula nested inside an IF statement that refers to another table on the same sheet. When I duplicate the sheet the second level nested references don't seem to update to the new sheet name but refer back to the original sheet.

The formulas looks something like this:
=if(trim(sometable::a2)"",offset(b3,0,count(sometable::b3:b12),1,1))

The trim updates and follows the new sheet, but the second level nested count locks into the original sheet name and has to be updated manually again.

This spreadsheet was originally made in the desktop numbers but not the forumla. I made that new in iPad numbers.

If this is a bug, where do we report it, as there is no report issue option like there is on the desktop version. Not that I have located.

Message was edited by: jaxjason

2 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Is there anyone else that can try this and confirm what I found, a complex formula (nested) then duplicate sheet. Some references stay pointing at the original sheet, not the new one.

    Thanks
    Jason

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    just marking as answered to get off my list. Have not ahd a chance to retest with 1.1 yet. but will resubmit trouble ticket to apple if it persists.