-
Have embedded report show collapsed by default on dashboard
Hello, I have a report that makes use of the new grouping functionality. I have it embedded on a dashboard (since use of the filters and grouping is not quite ready for prime time with the report app). Even if I collapse all of the groupings in the report before saving, it still renders as completely expanded when embedded…
-
Grouping issue in a report
Hi all, I have a report that includes tasks (primary) and assigned resource (person, using contact list) pulling from about 70 sheets - all with identical columns. When I group by the assigned resource, the report it's still splitting a several of the same resources into two different groups. I've double checked there…
-
Weekly completion running report
Hello, I am trying to create a report for our operations teams to track how many assignments they complete from M-F & then have the report reset on the following Monday. I had previously set up their metrics report using the "In the last _ days" filter, but that is inadequate for them since they want to see their weekly…
-
Grouping without sorting by that grouping?
I have a row report that I need grouped by one column and sorted by a different column. The grouped column is sorted as text and is showing 1, 10, 11, 12...2, 20,21... The column that I want to sort on is sorted as a number which is correct. Any ideas on how to break what SmartSheets has built in?
-
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…
