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?
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!