Can I Cell-Link between a Sheet and a Report
I want to use data the I've created in an RGY Report (it captures multiple sheet input) in another sheet for Metric reporting. I'm collecting RGY statuses from different sheets, summarized by Document Type (SOW., Service Form, Contract etc..). This works but I want to put that data in a Dashboard as a Metric, because the Chart widget limits how i can display the data. If I had a Sheet to pull in the data from the RGY Report and then create a Metric Report i can pick/choose the cells i want to present.
Any workarounds to pulling that report data into a sheet?
Thanks for the guidance.
Best Answers
-
Hi @Rick Girard
There currently isn't a way to create a cell-link between a Report and a Sheet, but please let the Product team know of your feedback by filling in this form, here!
If you're just looking to display the numbers, what about using a Report Widget with the Group/Summary rows auto-collapsed so it only shows the summary row data? (See: Using Report Widgets)
If I've misunderstood how you're looking to display this data, it would be helpful to see some screen captures of your current Report and maybe a dummy data of what you'd like to see in the Dashboard, but please block out sensitive data.
Thanks!
Genevieve
-
Yes, i was thinking about that, create 3 reports RGY and display the single output R....G....Y... from each and put it on the dash. thanks for validating !
Answers
-
Hi @Rick Girard
There currently isn't a way to create a cell-link between a Report and a Sheet, but please let the Product team know of your feedback by filling in this form, here!
If you're just looking to display the numbers, what about using a Report Widget with the Group/Summary rows auto-collapsed so it only shows the summary row data? (See: Using Report Widgets)
If I've misunderstood how you're looking to display this data, it would be helpful to see some screen captures of your current Report and maybe a dummy data of what you'd like to see in the Dashboard, but please block out sensitive data.
Thanks!
Genevieve
-
thank you, i did submit a form request and hope others have requested the same so it can be developed. I do use the report widget and if it could be filtered i could get what i'm looking for, but you can't do that either. :-\
-
Hi @Rick Girard
Thank you for clarifying!
You're right, you would need to build the filter directly into the Report to display different information. What about creating a clone of your Report (with "Save as New") so that you can display different pieces in multiple widgets?
-
Yes, i was thinking about that, create 3 reports RGY and display the single output R....G....Y... from each and put it on the dash. thanks for validating !
-
Seems like every time I search for a need that would simplify and automate a workflow the answer is, "submit a feature request."
Smartsheet - when trying to coordinate lots of data between two different teams managing multiple projects across 30 different countries, a report is a great central location to create only necessary links between domains. A roll up sheet has to be opened to be updated.
