Row numbers



I have seen multiple threads around this but still I'm surprised there is no dynamic solution for this, I have tried auto populating ROWID by AutoNumber column and as you can see in screenshot whenever I try to add a new row in between it calculates the row number from the bottom (WOW), this is very bad and this is causing my notification to sent incorrectly.

I tried =RowID1 + 1 which autopopulates the rows ID, but when I insert a new row in between two rows it doesn't work.

Is there any formula that can help with auto populating row IDs? even when we insert a new row in between two rows?

Best Regards

Amit Wadhwani, Smartsheet Community Champion

Smartsheet CoE, Ignatiuz Software, Exton, PA

Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!