I have a dashboard widget that displays a pie chart. The pie chart shows the number of high, medium and low priority "issues" recorded in a sheet. I have built this into a workspace which I copy to use on various projects - sort of a template set equivalent. Is it possible to "pre configure" the graph to use specific…
I have a sheet similar to the one below: I need a way to display my results like this: I can create a report but it won't sort it based on the aggregate function. Any help would be much appreciated.
So, I am having an issue with my published dashboard. I have embedded a report utilizing the current user function. I have found that when my team accesses the dashboard by manually navigating to it through SmartSheet, the report works perfectly and they are able to view it. However, when they use the published link (which…
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…
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…
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.
Metrics were working fine until today then the above appears in place of all formulas = dashboard not working too
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…
