Formula Refers to Worng Row

dschaefer

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?

Andrée Starå

Hi,

Try changing the row reference to @row so you don't have to worry about them.

Something like.

=ID@row + " - P/N " + [P/N or Item #]@row+ " " + Client@row + ", " + [Short Description]@row

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD