Formula Refers to Worng Row
I have a SmartSheet that was created with nothing assigned to the primary collumn. This means many email notifications have no reference to what row or item it refers to. So, I added a formula to concatenate other collumns into the primary:
=ID1 + " - P/N " + [P/N or Item #]1 + " " + Client1 + ", " + [Short Description]1
That gives me something like:
S-100 - P/N 12345-ABC Client, LH Widget
The problem is that as new rows are added, at some point the formula ends up referring to another row. We have several team members adding rows to this sheet, usually through a form, but not always. I haven't been able to pinpoint what action ends up making things off. Once a row is off, all subsequent new rows end up off.
Why does this happen and how do I prevent it?