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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!