Contacts Column Update

Apologies if this is someplace else, I could not find it.

If I have a column in a sheet that is a Contact List and I want to update what is currently there, how do I propagate that change in the rest of the sheet and so it's available in the dropdown in a form?

More specifically, if I change Chavez to Chavez Construction via the bottom cell (by editing it) how do I make sure it changes it in all the cells in the sheet so reports are correct and so the choices on the form dropdown are updated?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!