-
How to Consolidate Entries from Multiple Forms
I've seen this question asked before, and the same answer is always given, "use an update request." Is there a way to consolidate information, because I don't think update requests are the best solution for our process. I have multiple forms with different types of information being entered at different times by different…
-
Create Chart Widget Using a Report (not a Sheet)
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…
-
Reports - Publish as iCal
Is it possible to publish reports as iCal? If not, this would be a great feature.
-
Indenting Text for Dashboard Exports
Hey Smartsheet Community! I am posting this in response to the Engage Product Vision sessions that Ben Canning hosted, where there was some talk about someday exporting dashboard content other mediums such as PDF, Powerpoint, Google Slides, etc. In my company's change management journey we have been working hard to…
-
How do I total the answers from a drop-down cell?
I'm trying to build a dashboard that will show the progress of sites completed for an upcoming upgrade. I have attempted several ways to compile this information automatically and I'm at a loss. I think a simple cell formula might be the easiest way to accomplish what I need then I can link the cell to a report I create.…
-
Grouping and Organizing Reports
Is it possible to use grouping in reports and manually arrange those groups? For example, I have groups (Initiation, Planning, Execution, Closure, Terminated) to group phases, but then I only have options to alphabetically (ascending or descending) organize those groups; this means I can't actually get the groups into the…
-
Pivot App Zero Values
Hi All, I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushing the data in these fields as number summary in the Dashboards/Portals. Other than creating new…
-
Can I keep grouped reports colapsed?
I have a grouped report below that I expand to update individual sheets. However when I return to the report each all are expanded that I have close again to scroll down more easily!. Is there a way to keep it collapsed?
-
New Blank Report not showing fields
Hi everyone, I am trying to create a report but it does not show the columns from the sheet, am I doing something wrong? I select the sheet that I want to create the report and nothing happens, I've tried refreshing the page, refreshing the sheet and nothing.
-
Enhancement Request: Hide formulas from Viewers in Reports
A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report. Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just hide the formulas. Or tell me why this is a good feature.
