How to keep current and archive records at same time

Hello All,

i have a sheet where it has a product column has product names. Few product names are updated and others are the same.

for ex. TCS becomes Tech Cost Service

i want to keep both records so i know which is updated or not.

is there any way, i can keep both the current product name and the updated name with new column?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!