Formula Refers to Worng Row

edited 12/09/19 in Formulas and Functions

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!