I have a spreadsheet that indicates the next "allowance day" for the next month. During 2025 the range item was "Allowance Days 2025::B1:B13". (see picture) When I updated it going into 2026 I made it refer to the 2026 table of allowance days. But my question is why is it labeling the parameter as "Allowance Days 2026 2025..."? How is 2025 even referenced? Thanks in advance.
iMac 24″, macOS 26.1
If you increase the width of the table you will see that the full name is "Allowance Days 2026 2025-1". The table is too narrow to show the full name. When you duplicated the Allowance Days 2025 table it created one with the name "Allowance Days 2025-1". You typed "2026" into the middle of it when you were renaming it but didn't remove the "2025-1".
I did not type 2025 into the new element. At least I don't recall doing it. I just clicked on the element that said 2025 in the edit state and replaced it with the 2026 table. What am I getting wrong? Can it the way I edited it? The sheet works the way I want it to but I am interested as to why 2025 and 2026 are named in the element. I do appreciate your help.
You were right! I had 2025 in the title of the table but could not see it. Thanks a bunch. How can I give you "credit" for the solution?
MD_Gene wrote:
How can I give you "credit" for the solution?
There's no way to mark an answer as the solution anymore, just upvote.
Updating Index Formula in Numbers Creates confusing change
