Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I'm trying to create a Sight that shows a high-level overview of a portfolio of projects. If the user clicks in the widget within the Sight I'd like them to go to a more detailed report on the project that they selected but only the project they selected - not all the projects in the sheet. Is this possible? Thinking of looking at using a filter on the report but not certain how to grab the value that was clicked on.
Hello,
You will want to use the metric widget to display the report values.
The Metric widget allows you to display content from one or more cells in a sheet. After selecting this widget type, click Add data to choose the sheet and cells that contain the data you'd like to display and then click OK.
NOTE: If you want to display the data in a grid format, you'll need to first create a report and use the Report widget type.
Once you've chosen the data to display, click Edit Interaction (interaction is what happens when you click the widget ) and choose Open the source sheet option. This will allow users to click on the widget and be brought to the detailed report. Please note that you will want to share the report and its source sheets for the user to be able to view the while sheet.
Kind Regards,
Pam
I found that if I add a hyperlink to a project/report/sheet in a report, and add that report to a sight, people can follow the link to the underlying project/report/sheet hyperlinked from the report.
Hope it helps
Randy
