Linking Contacts to Companies: Tips for Your Find People List

·

Morning, when building a "Find people list" is there an easy way to link the sheet to the companies list to tick off the companies I have contacts for? I have a checkbox column on the companies list that I would like to tick if I have a contact 🙂 Or can I create a column that reference the contacts against the companies in the company list?

2 comments

· Sorted by Oldest

kushagra tiwari
·
·
You can do a lookup based on company domain in the company table - targeting the people table.
kushagra tiwari
·
·
1.
You will get the results of all people in the column for the companies which have associated people
2.
For companies where no people were found the column will say no results found.
2

kushagra tiwari
·
·
You can do a lookup based on company domain in the company table - targeting the people table.
kushagra tiwari
·
·
1.
You will get the results of all people in the column for the companies which have associated people
2.
For companies where no people were found the column will say no results found.
2