-
Start and end date line chart
Hi Team, Can anyone help me how can I create a line chart based on below information. I
-
Dashboard Widget Source - Template Project Tracking and Rollup
Hi, I'm using the Template Project Tracking and Rollup. On the Dashboard that comes with it, I'm unable to find out the cells in the source sheet that are populating the section "Add Project Contacts". It seems as though it's hidden somewhere. Any tips? Best,
-
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
