Copy Primary column data to Contact list column

Today we have a primary column with the user information but defined as Text field. We are looking to have it as Contact list but as it is a primary column we cannot change.

As a work around we created a new column but how can we make sure that column is filled in from Primary column ? I see there is no option to make it as mandate field so looking to automate and copy the field

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!