Skip to content
Cross Doc - Reverse LookUps
How to: Cross Doc Reverse Lookup
Doc #1
Doc #2
More
Share
Explore

icon picker
Doc #1

Instructions:
0. Pull in Cross doc tables into both docs
1. Create a 'Row ID' column in the First Doc table using the RowID formula
2. Create a new column in the Second Doc table 'Doc 1 Row ID' and use that formula to find the associated row ID in the cross doc table
3. In the First doc, add a column to the cross doc table to match the row ID between the two tables (Creates the link between the 2 tables in the First doc)
4. Set up the Reverse Lookup column formula in the First doc table that matches the row IDs
OKRs (Source Table)
0
Name
Row ID
Projects
1
Brand Awareness
1
Project 1
Project 3
2
Product Stability
2
Project 2
3
Customer Advocacy
3
Project 3
There are no rows in this table
⁠

Projects (Cross Doc)
0
Row
Name
Doc1 Row ID
OKR
1
Project 1
Project 1
1
Brand Awareness
2
Project 2
Project 2
2
Product Stability
3
Project 3
Project 3
31
Brand Awareness
Customer Advocacy
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.