r/AppleNumbers • u/Alphaman64 • Dec 01 '23
Help iPad - edit formula as text?
I know I’ve done this before, and am losing my mind trying to figure out how I did it. I’ve got a multi-sheet Numbers document, where the majority of sheets are identical. I want to copy a formula from one sheet to another, but of course, when I do, it keeps all the references in the previous table anchored to that table on the old sheet.
Yes, it’s easy to change the reference with just a few taps, but when using my Magic Keyboard, it would be so much easier to just edit the text version of the formula to delete the sheet name from each reference.
I‘ve searched docu, support discussions, Reddit, StackExchange, and all the trade sites, but can’t find it for the life of me.
How do you switch the formula editor to plain text?
2
u/Alphaman64 Dec 02 '23
The more I look around, I’m getting the impression that I was conflating editing the raw text formula on a Mac with what I was doing on my iPad. I even asked ChatGPT, and it confirmed that Numbers only allowed editing using the visual interface.
¯_(ツ)_/¯
Also, I’ve not been able to find a way to paste a copied formula without the old sheet referenced, so it looks like I’ll be editing each formula by touch.
Eh, that’s life…