widgets
Discussion List
-
How to make a sheet that only shows the last x entries of another sheetIn Using SmartsheetHello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am …
-
Color item no longer representing on dashboardIn Using SmartsheetI have a sheet where a person sets project status. They can choose Green, Yellow, Red, Grey or Blue. Since Smartsheet cannot handle 5 color lights, I do the following. The person can set G, Y, R or Grey directly. If their project is lau…
-
Looking for an automated way to Pareto Dashboard data in a Chart Widget from a ReportIn Using SmartsheetI have large datasets with various records that have spikes and some that have only a few occurrences. Right now I have things structured in a main sheet where all the data is entered, then a summary sheet with the potential values (which …
-
Dashboard Chart Widget Axis changes with each refreshIn Formulas and FunctionsThe axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. …
-
My chart made from a report will not show the date information on the horizontal axis.In Using SmartsheetWhen I make a chart from a report the date does not show up. If I make it from a grid sheet the date is there. Using a sheet means I have to update it manually each day. How can I get the date to show up on a chart using information from a…
-
Unable to select data range for a dashboard chartIn Using SmartsheetI am trying to insert a chart on a dashboard, using a report as the data source. However, when I select the report it does not allow me to select the data range I want (it defaults to select the entire report). What's more, it won't even …
-
Dashboard Widget Source - Template Project Tracking and RollupIn Using SmartsheetHi, 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 hid…
-
Saving default colours for dashboard widget graphsIn Using SmartsheetI 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 …
-
Donut Widget - Scale looks to be offIn Using SmartsheetThe blue portion of the donut does not reflect 33% complete of the entire donut. How do I make the blue section represent the % more accurately?
-
Dashboard Image Widget not working on Ipad/Android mobile devices.In Using SmartsheetI've create image widgets on my dashboard that work great on my desktop. However, on the job site while using my Ipad or android devices the images will not open when selected?
