-
Getting latest data onto a Dashboard from a sheet
I have a "project risk log" in a smartsheet where every risk is scored from 1-5. I have a separate "summary" smartsheet which has formulas in to count the number of "open" risks in that log for each score from 1-5, ie there is a column in here for score 1 where all of the open risks in the log with a score of 1 are…
-
Dashboard question
New smartsheet user here. I have a number of spreadsheets (or grids) that I want to display on a dashboard. So far as I've been able to determine, in order to do that, I have to create a report that essentially duplicates the spreadsheet. (If this is wrong, let me know please) Once I add the report to the dashboard, using…
-
Piechart does not reflect the correct percentage-Showing 100%
My pie chart is linked to a cell that says 25% complete. The pie chart says 25% but has (100%) next to it and shows a whole pie chart. I was hoping it would show only 25% of the pie not the whole pie.
-
#INVALID Ref in metrics sheets
Metrics were working fine until today then the above appears in place of all formulas = dashboard not working too
-
Auto expand section of dashboard.
Is there a way to set a field on a dashboard to automatically expand to fit all the data? I have a report that shows the topics coming to a meeting in the next 30 days. This field will change often. Can the field be setup to move everything down on a dashboard instead of making people scroll or for me having to go in and…
-
Guidance needed on Scatter Charts- Issues encountered
@Andrée Starå @Brendan Reed or anyone else, is there a step by step for using the scatter chart? I am trying to graph 2 numerical columns for specific project rows, but the x axis is showing everything as '0', vs. the true value indicated; it is also separating the rows of data into two different places on the chart; e.g.…
-
Intranet in Smartsheet - Anyone Successful in Transitioning Policies and Procedures
I am attempting to transition our current Intranet over to Smartsheet and the biggest hurdle I currently have is around Policies and Procedures. We are a ISO certified company so document control is a important issue for us. Our current platform allows for linking within one procedure to possible several other procedures,…
-
"No data to display" on 0% Chart
Hello, We have been hosting a data dashboard on smartsheet for quite some time and one of the recent updates now displays an inaccurate title of "No data to display" on a few charts where we are essentially plotting 0 misses (a good thing). This is aggravating because it suggests that we don't have an input, but in reality…
-
Graphing Only Total Row From Summary Report
I want to graph my summary row of my report; however, when I select the report it does not give me the option to modify what is selected to be included in the graph which is the entire report. This report is built of summary data from about 50 different sheets so doing this using a metric sheet is not really an option that…
