-
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…
-
Link sheet to rotating cell in feeder sheet
My team is trying to create a "wrap up" type sheet that pulls data from child sheets that are updated monthly from a form. The data in the child sheets that needs pulled are the most recent submissions from forms associated with the child sheets which means the cell will constantly change. Is there a way to link these…
-
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…
-
Totals From SUMIFS Displaying Incorrectly Within Sheets and Dashboards
Hi all, Wondering if anyone has any ideas or insight into data not displaying properly within graphs on a dashboard. The issue I experience is that data displays during the wrong 'time' or is assigned to the wrong criterion. Here's the issue: I have a data sheet that gets multiple form submissions per hour - sometimes…
-
Refresh Sheet Without Opening It?
Hi All. Can anyone suggest how to refresh a sheet without manually opening it? Reports on my dashboards are displaying errors related to linked cells not refreshing. For the last year, until last week, I had a workflow in place that "locked a row" at midnight and then unlocked a row at 1am. The workaround no longer works…
-
Dashboard will not save
I have a growing number of dashboards that will no longer allow edits to be saved. These dashboards were created in the last 3 months, and suddenly in May, they will not save. I have reported the issue to Support, but have not yet received a response. Is anyone else having this issue? I have rebuilt one already, but would…
-
Collaboration of Project Plans
Hi We are using smartsheet to manage all of our customers onboarding projects in the Professionals Services department. We have global team that share resources globally. What are the best practices we should use in order to share all projects among all team members and have reports/dashboards that will highlight project…
-
Malfunctioning dashboard widget based on Pivot report
Hello, My dashboard widget is showing the grand total column even though this is not a column I have selected on the source pivot report: Grand total showing: Grand total not an option in the "Columns Included" option: This columns header is not selected in the report (sourced by a pivot sheet). Can someone help me…
-
Is there a way to create a 'collapse section' on a Dashboard?
I'd like to truncate the Dashboard view for my users so that they can select what they want to see by Section Content (eg Project Progress, Project Resource Links, News/Updates etc.), instead of everything being available as a huge data dump a mile long. Is there a functionality to expand/collapse sections on dashboards…
-
How can I chart the last 7 days that contain data?
Hello, I am capturing audit data utilizing the web form for smartsheet, and would like to use a line chart to show average compliance per day, for the last 7 working days. With the holiday weekend that just occurred, I have a 3 day hole in my chart. I have been brainstorming and am trying to come up with a formula that…
