Formula for transferring information between columns


I am looking to transfer the numeric value from the column named Dept name to the Dept # using a formula. The Dept Name information is autofilled from a form. I would like when a single dept name is selected for the numeric value to autofill in the Dept #. If multiple Department Names are selected I would like it to register as XX under Dept #. See attachment for current layout. Any suggestions are very appreciated.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!