Row numbers

Hi,

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

https://www.linkedin.com/in/amitinddr/


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

Tags:

Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!