-
Source reports inaccessible from view only dashboard (sheet deleted error)
We have had an embedded dashboard with report widgets operational all year but am now receiving an error when attempting to open the source reports, but only from the view only dashboard. The error says "The sheet you were trying to open has been deleted". The reports still exist, are also published, and can be accessed…
-
Add metric from multiple sheets
Hello We have many sheets located in a workspace and I want to show a metric on the dashboard where it sums up all columns with the Task Status showing "Completed". What is the best practice? I dont want to add a sheet summary to the dashboard. I want to point out a particular metric. Thanks very much
-
Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of…
-
What is the simplest way to have data from a form be pulled monthly into reports/dashboard
I have created a smartsheet form to log information on service intakes. I have then created sheet summaries and reports with a bunch of information (age, demographic, reason for call, type of service requested etc.). From this I created a dashboard showing key metrics and graphs of my data. My challenge is now I would like…
-
Make it so that a dashboard and all its components (widgets) belong to the owner of the dashboard.
Currently, a dashboard's components do not belong to the dashboard's owner. If another user adds or edits a widget on a dashboard, that widget does not belong to the dashboard's owner. Instead, it belongs to the person who added the widget. This means that if a dashboard changes ownership, the dashboard will break when the…
-
Displaying Upcoming Tasks in a Dashboard
Hello, I'm currently exploring the most effective approach for showcasing upcoming tasks scheduled for the next month. The data is organized into three columns on a report (but I have sheet access to the data too): the first column indicates the month of publication (with a subheading or nested section specifying the task…
-
Attaching Excel file to dashboard
Is there anyway to attach an excel file to a dashboard where when you click the link or image it will download a copy instead of opening a web version. I want people to be able to click on the link and have a copy download and open so they can input data and the save this excel file and then attach it to a row using forms.…
-
More Dynamic & Interactive Dashboards
Dear All, I love the Smartsheet Dashboards which are very dynamic with real time information. However what would be even more awesome if we could use variables or options in the Dashboard to change the displayed information similar to Microsoft BI. For example if we are displaying the daily Sales figures for a particular…
