How to update a column formula for new ID prefixes

Hi everyone, I am not sure if I am going to explain this correct, but here it goes:

Last year, with the help of engineers at Smartsheet, I had built a project management suite for one of my agency divisions. We have everything from dashboards, to meta data and archive sheets. I wanted to replicate this management suite to another division that was also in need of a system to track training delivery. In doing so however, my master project sheet at the parent level is stuck using old prefixes in my new column ID. I changed the column formula to include the new prefix, but the old prefix and number system still generates upon every new created row.

Any help would be appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!