Automatically populating a field using value from a linked sheet

How do you set a field to automatically populate using the value in a linked sheet? I’m trying to automatically populate the ‘event’ field using the value (free text format) in the ‘Events’ sheet, but the only choice I have is “select from other sheet.” I have almost 10,000 entries for which the ‘event’ field needs to be populated, and there are more than 400 possible selections. So, even using mass update, this is a long and laborious process.



To automatically sync loaded fields from the linked source sheet, please refer to this document.