-
Data Over Time Report/Dashboard
Hello, What steps should I take in creating a dashboard that includes a graph displaying data over time? I would love to be able to click on each data point and a pop up of that data point displays information during that time period. Here is an example of something I would like to create in Smartsheets
-
Smartsheet to SQL Server
Hi Team, Just curious Is it possible to link Smartsheet to SQL Server to fetch data?Thanks
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
Can I access/download spreadsheets I previously made without paying for the upgrade?
I no longer have the need to use the Smartsheet service but I would like to e able to refer back to the reports, sheets, etc. that I made while using the upgraded version. Is that not possible?
-
Create report OR DataMesh to pull information from MetaData Worksheets
I have a client ask for a report. There are 150+ stores involved in the report. MOST of the information I need for the report can be found in each of the MetaData sheets. The challenge however, is that the MetaData sheets are buried two folders deep in the Workspace. How do I either create a report or a DataMesh that will…
-
Can a paid user pull a report that shows all of their published sheets and reports?
I am a Smartsheet System Admin and we are considering changing the corporate level setting to "Published…available to users in the owners account” from “Published reports/sheets are available to anyone with a link". I will need to communicate this change out to the 600+ paid license users in my company so that they are…
-
Workspace Column in Reports
When running reports, they are often from multiple workspaces. Each department has their own workspace with their own project plans. It would be helpful to have a column where it could pull in the workspace name where the sheet resides. Then the report could be grouped and summarized by this column to get a count of how…
-
Allow List View of Reports in WorkApps when viewed on Mobile
Issue: When adding a Report to a WorkApp, it defaults to "Grid View" and cannot be changed to "List View" when viewed on Mobile. Makes the WorkApp feature utterly useless on Mobile due to not having Reports viewable in a Mobile friendly way.
-
Report Sorting on Non-Included Columns
Right now, on reports, you can add a column, sort by it, and then remove the column and the sort remains (at least when I test it, it does). However the Sort menu shows blanks. This can also be a tedious process - adding columns just so you can sort by them and then remove them. The Filter function on a report works on ALL…
-
Descriptions and Notes in Reports
Was suggested and is a great idea that when creating reports there be the ability to add overall notes/descriptions for color coding or explanation of summaries.