Formula for transferring information between columns

Aaron Olsen

Hello,

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!

Annotation 2020-10-22 151933.jpg

David Joyeuse

Hi @Aaron Olsen

I would first suggest this!

=IF(COUNTM([Department Name]@row)>1, "XX", LEFT([Department Name]@row, 2))

Hope it helped!

David Joyeuse

Hi @Aaron Olsen

I would first suggest this!

=IF(COUNTM([Department Name]@row)>1, "XX", LEFT([Department Name]@row, 2))

Hope it helped!

Aaron Olsen

This worked perfectly! Thank you!