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…
@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.…
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,…