Linking information
Hi
Is there a way to link folder names and drop down list items to a cell?
I could then f.ex. have a sheet with overall Project Info where i list a number of sub projects, then create a folder named through a link to the sub project name in the project info sheet. In the same way maybe i want to assign some sort of a task/action/objective to a sub project, is it possible to create a drop down list from "Metric data" like in the dashboards?
Comments
-
I am not sure if this is EXACTLY what you are looking for, but you can copy/paste the URL into the Hyperlink section. This works for sheets, workspaces, reports, dashboards, etc.
If you have a folder with multiple items in it, and you want to create a hyperlink to the folder itself, simply navigate through your home page until you are in that particular folder. Without actually opening any of the items, highlight and copy the URL.
Go back to your sheet, right click on the cell you want the hyperlink to be in and select the hyperlink option. You can then paste that URL into the appropriate box (and probably want to have a clearer display text). When someone clicks on that hyperlink, it will direct them to the folder instead of a specific sheet.
You will see this in the screenshots below. When I click on the hyperlink, it takes me back to the folder seen in the second screenshot.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives