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


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

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!