Skip to main content
Point each row at its row in another table, such as each person at their company, and bring back the values you need. On the other table, count the rows pointing at each of its rows.
The Tools panel open on its Your data tab, listing Link to another table and Count rows pointing here under Your tables, above Connected tools.

Both columns, under Your tables on the Your data tab of Tools.

1

Open Your data

In a table from Tables, click Tools and open the Your data tab. Choose Link to another table, under Your tables.
2

Pick the other table

Under Link to, choose it in Table. A pair of columns whose names match is filled in for you.
3

Choose what to match on

Under Match on, pick a column in This table and the column holding the same value in Other table. Add a pair adds a fallback, up to three pairs.
4

Pick the values to bring back

Tick each value under Bring back. Tick Own column beside one to give it a column of its own.
5

Create the column

Save it and run it. Linking is free.
A line under the pairs counts the matches as you choose them, such as “312 of the first 500 rows match”. It also counts the rows with nothing to match, and lists a few values the other table does not hold.

​
Read a linked cell

The cell shows the other row’s name as a chip, taken from Shown as. Click it to see which column it matched on and every value it brought back.
  • Open in Companies opens that row in the other table.
  • The + beside a value gives it its own column.
A row whose value matches nothing reads “Not in Companies”. A row with nothing to match on is skipped.

​
Count the rows pointing here

1

Open the other table

On the table being linked to, such as Companies, click Tools, open Your data, and choose Count rows pointing here.
2

Pick the table and its link

Under Rows pointing here, choose the Table that links here, then its Link column. With only one, it is picked for you.
Listed as sets the name each row goes by. Click a count to list the rows pointing at that row, each one a link to it. A link updates itself. When the other table changes, only the link cells that changed update, and the columns reading them run again like any other dependent cell.

​
Good to know

The pairs are tried in order, and the first pair whose value the other table holds wins. When several rows hold it, the one highest in that table wins.Matching ignores case, spacing, https://, www., and a trailing slash, so www.acme.com/ matches acme.com.
The value in the column chosen under Shown as. Left on Automatic, a column that holds a name is picked for you. A row with nothing in that column reads Linked.
Point at it to read why. A value that came through a link of its own cannot be brought back again, so links never chain. A column holding a whole record cannot be brought back either.
A cell edit counts, and so does a finished run. So do rows added or removed, and the table moving to Trash or coming back. A linked table in Trash fails each cell with “The table this column links to is no longer available.”
Up to 20,000 rows, for the table you link to and the table you count from. A bigger one fails each cell with “A linked table can have up to 20,000 rows, and this one has more.”
A people search that follows a table made it, and the search keeps its table and pairs. You can still change Shown as and Bring back. See Saved searches.
A link writes the other row’s name, and a count writes the number. See Export a file.
A chip linking to the row it created in the other table.
Yes. Ask it to link a table to another, change a link, or count the rows pointing here. See Chat.

​
Next steps

Reference other columns

Read a value from another column of the same row.

Saved searches

Find the people at the companies in a table you already have.