Need a way to fix row id, so they do not move

Hi,

Little background, I am using below formula to get the row id in RowID column

=COUNTIFS($Name$1:Name@row, OR(@cell = "", @cell <> ""))

Now whenever I sort my sheet on the basis of date, the row ids also changes because the absolute reference changes. I am fine with sorting but I want the Row ID to always start with 1 and so on.. (i.e. it should remain same), anyway to achieve this?

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:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!