This is how to link a Smartsheet to an existing sheet: Open a summary sheet and place your mouse over the cells you want to link in. Start at the top row. Right click and select “Link from cells in other sheet.” Select the sheet you want to link to and click on it.
How to link smartsheets together?
Here’s how to link cells:
Log in to Smartsheet and open your destination sheet. Right-click on a cell and choose Link from Cell in Other Sheet. Alternatively, you can click the cell and click the Cell Linking button on the left (the one that looks like a chain link)., and more items.
Another frequent question is “How do I add a URL to a Smartsheet?”.
The URL will appear in the “Display Text” field, but only if there is no text in the field. Click on the “Link to other Smartsheet” option. Click on “Select Sheet.” The “Open a Sheet” form will appear. Select the sheet to be linked to and click “OK.” Enter or Edit the text in the “Display Text” field.
Another popular inquiry is “How do I offer public access to a Smartsheet?”.
Public access to a sheet can only be offered by linking to a the published URL for the sheet. Enter or edit the text in the Display Text field. NOTE: This field is required if you selected the Link to other Smartsheet option. If you selected the Link to URL option and do not enter anything in this field, it displays the URL.
How do I link a sheet to a published sheet?
The Open a Sheet form appears. Select the sheet to which you want to link, and click OK. NOTE: Sheet links will not appear in a published sheet. Public access to a sheet can only be offered by linking to a the published URL for the sheet. Enter or edit the text in the Display Text field.
It’s not possible to link entire sheets, columns, or rows. Only cells that contain data, or that previously contained data, can be linked to a destination sheet. Cells can’t contain both a hyperlink and a cell link.
How does Smartsheet update the summary sheet?
When information is updated in the source sheets, the summary sheet is automatically updated. Whether you are rolling up departmental budgets, partner sales forecasts, annual headcount, operational plans, or client project summary dates, Smartsheet does the work for you. No more copy and paste!