I have a sheet called "Money"
Now I want to have a cell update its own content based on the name of the sheet, so if I change the name of the sheet to "Shopping", then the cell would also change to "Shopping".
I have found this thread, but for some reason it's not working for me, any of the solutions they provided:
I tried copying and pasting what they have, also tried doing it manually. No luck.
I have Numbers 11.1
I didn't try the solutions given in the link. They are more complicated than necessary now that we have some additional text functions. I saw that the provided formulas used semicolons, not commas, between parameters in the functions. That might be the problem you ran into. They were written for regions that use the comma, not decimal point, as the decimal separator.
=TEXTBEFORE(REFERENCE.NAME(,2),"::")
You're the master! Worked like a charm!!!
Thank you SO much! :)
NUMBERS: How to insert sheet name into a cell?
