Sheets, or partial sheets displayed in 'Sights' dashboard

I know several of us use cell linking to creat roll-up reports of our data, but these reports cannot be displayed in a 'Sight', becase they live on a sheet, not on a report.

Is there a way, or can i recommend a functionality, that allows for a sheet, or part of a sheet to be put into a sight for quick visibility?

Unfortunately, my report can't be displayed because it was not created as a "Report".

Thanks,

Find more posts tagged with

Reports

Dashboards

Project Management

Comments

Christine Oakes

Brian

You can create a Sheet Data widget in your Sight and pull in individual cells from your sheet.

Christine

Christine Oakes

Sorry Brian - meant Metric Widget, not Sheet data.

Brian Smith

Thanks Christine. I'm looking for something that looks like the 'report' widget, where it shows up in a grid view.

If I were to do a metric or sheet data widget, I would have 5 rows by 4 columns of data listed down the page (20 entries long, with no identifiable correlation between terms).

Brian Smith

My workaround:

I have a source sheet, where I have a section at the bottom doing all of my formulas.

I then cell link the formulated rows, and any others that I wish to have appear on my 'sight' to a 2nd sheet.

From there, I create a report that reports against all cells in my 2nd sheet that 'are not blank' (essentially reporting the exact contents of my 2nd sheet - they are identical).

So, unfortunately this workflow requires 2 sheets, & a report in order to get the information into my 'sight'.

Chuck Muirhead

Brian, I feel your pain. There is no big difference between Metric and Sheet Data widgets as they build vertically, which does not represent the sheet data I want to display, so I must create reports from various sheets and then add a report widget to the Sight. In my case, I have to create over 270 reports in order to place 3 unique pieces of data on 90 Sight Dashboards.....I love sights already, but there is a ton of up-front work and manipulation to get items to show up as I want on the Dashboard.

Travis

Hi everyone, this is something we are looking into adding to Sights in the future and I will submit your feedback to the team working on Sights!

erangak

Hi,

What is the latest status of this feature? How soon can we see this?

thanks,

Eranga

Joanna

Would love to display a section of a Sheet instead of a Report as a Dashboard widget. Sheets give me more flexibility to do things like Indent to create child rows, and format rows/columns/cells.

I, too, am using a workaround and as a result, I am creating duplicates to satisfy the report criteria.

Richard Heath

Hello,

Has there been any further movement on this? The Metric widget reconfigures the Sheet Data in a format that doesn't suit our needs.

Displaying a fixed range of cells from a Sheet would seem like the obvious solution.

Richard.