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.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!