So I have two boards - one with the names of suppliers and one with the names of contacts.
I have hand selected the correct ‘supplier’ in the connected column on the ‘contacts’ board (eg the ‘monkey’ example, above’) but am now wanting to automate the completion of the ‘contact’ column on the ‘supplier’ board.
I can’t for the life of me figure out how to do it.
I have tried ‘finding matching item’ but it doesn’t look like a match is found if the match in question involves a match in a connected column.
I swear I have done this before but just can’t figure it out!