Autogenerate IDs built off of other IDs?
Hello! I'm trying to auto-generate IDs that build off of another ID. The formula I'm currently using is:
=[Initial ID]@row + "-R" + COUNTIF([Initial ID]:[Initial ID], [Initial ID]@row)
I would ideally have it set to:
=[Initial ID]@row + "-R" + COUNTIF([Initial ID]1:[Initial ID]@row, [Initial ID]@row)
But that's not allowed in Smartsheet at the moment. Is there any way to run this so the IDs get numbered in order of being added and stay that way, rather than changing as more are added?
This picture hopefully demonstrates my issue. I want them to count up and have old ones not update.
Help Article Resources
Check out the Formula Handbook template!