Create a link
Jatin Arora
Last Update één jaar geleden
- Open any application.
- Click on “Open Sheets” in the top bar.
- A view that displays your sheet's data opens up. Go to the sheet (Ex, Employees) where you want to create a link
- Click on “New Sheet Link”
- Select a sheet to be linked (Ex, Projects)
- Make sure that the sheet to link has an ID column (Ex, Project ID in Projects)
- Input linking logic. Link rows if column value in the current sheet (Ex, Project ID in Employees sheet) is equal to ID column in linked sheet (Ex, Project ID in Projects)
- A new link column (Ex, “Projects” column in Employees) is created to represent how current sheet is linked to the selected sheet
- Another link column is auto created in the linked sheet too linking the current sheet data to it (Ex, “Employees” column in “Projects”)