Is there a better way to do this? Simplified example below.
I have 2 boards:
- Companies - each company and their contact info
- Contacts - each contact and their individual contact info
These 2 boards are linked so that the COMPANIES board has a column displaying the connected CONTACTS, and, vice versa, the CONTACTS board has a COMPANIES column.
Now, let’s say I have to add 10 new contacts to 10 different companies. Let’s say I import those 10 new contact entries from a simple excel sheet. There seems to be no way to import the company names since it’s a connected board column? Is that right? Or am I overlooking something?
What I’ve done so far is import the COMPANY data in as a separate text column. Then, I go back through each individual line of data and click to select and link the company.
Is that the only way to get the info into the board and connected? Manually?
This is super time consuming. If there’s a better more efficient way, please let me know!