-
I need to SUM points based on user and then sort by aggregated points
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.
-
Dashboard access via link not showing the user as logged in.
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…
-
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,…
