Hi,
I have the same table in two different sheets, both formatted as tables.
Both of the tables have a column named "PA ID".
I have a column where I want to calculate something based on this PA ID, and the reference is different.
In the first the reference has to be: [@PA ID]
In the second the reference has to be: [@[PA ID]]
My question is: Why is the difference?
It would be nice to have the same, because I have to use the same formulas in multiple columns and I always have to replace the wrong references, but hey, the columns have just the same headers! So I'm really curious how I can ensure that the reference can be the same.
Thanks in advance!
I have the same table in two different sheets, both formatted as tables.
Both of the tables have a column named "PA ID".
I have a column where I want to calculate something based on this PA ID, and the reference is different.
In the first the reference has to be: [@PA ID]
In the second the reference has to be: [@[PA ID]]
My question is: Why is the difference?
It would be nice to have the same, because I have to use the same formulas in multiple columns and I always have to replace the wrong references, but hey, the columns have just the same headers! So I'm really curious how I can ensure that the reference can be the same.
Thanks in advance!