Duplicate sheets messes up nested formulas?
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.
- 0
- 0