Numbers change referred formulas when row added

Hi,

I've got a problem with numbers. I've made a template with words and numbers where I refer to all my information in the next tab (they are all organized in A1:*1). When changing these values, they perfectly change in my template as well.


Now, I want to use iOS shortcuts to insert new information in the top row. However, the template formulas now are all referring to A2:*2 instead of the original reference. Even with "$", the cells are still changing and won't accept my new row of information as value.


How can I use the new added row of cells as referred cells to my formulas?

MacBook Pro 13″, macOS 15.4

Posted on May 21, 2025 3:29 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers change referred formulas when row added

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.