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