-
Creating charts with multiple criteria without summary sheets and thousands of distinct formulas
I have a grid that contains an employee's level of expertise is a specific skill. There are 90 skills listed (columns) and around 50 employees. Each cell contains None, Beginner, Intermediate, or Expert. There are additional columns for each employee's name, department, and whether they are 'Active'. In order to create a…
-
Source Sheet Conditional Formatting on Dashboard Web Content Widget
Over the last few weeks, I have received notifications from users that the Conditional Formatting on a Source Sheet is not accurately reflecting on the Dashboard that our end-users are accessing. The Conditional Formatting on the Source sheet is reflecting as expected. However, the dynamic view is incorporated on our…
-
Required advice on creating a view on Overdue tasks
Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?
-
Unable to Save Dashboard Widgets
Hi, I'm unable to save the dashboard after adding the widgets. I receive following error message: "Validating Request - Dashboard 203198926 plan is not active." Anyone facing the same issue? Thanks.
-
New PDF Symbol on Dashboard?
Does anyone know why the PDF symbol is now looking different on Dashboards? I know it is not a big deal, but the document just looks off with the name of the document overlapping the symbol. Has anyone else noticed this on their Dashboards as well?
-
How to access all columns in a Report when creating a Dashboard Chart?
Hello! I have a report that is summarizing project costs, sorted first by the line-item code in the budget and then by Quarter of Completion afterword. I am hoping to represent this data graphically with a dashboard chart. The goal is to have a Bar Graph that shows the cost in each quarter, clustered by the budget item.…
-
How do we make Graphs look the same on desktop and mobile dashboard
We have a dashboard that has 3 graphs in it, based on reports. On the desktop version Y axis starts at 0 and has specific colours for the different lines. On the mobile version the y axis starts at -2 and has different colours for the lines. This is on all 3 graphs. How do we make them be the same graphs?
-
Dashboard widget cant save as it request data validation
hi im using smartsheet trial version. im trying to create a dashboard of my reports from various sheet but it cant be saved and requesting for data validation. can help me on this?
-
Dashboard to show Report's Highlighted Changes
Hi! I setup a report to show the most recent changes but the formatting is not coming over on the dashboard. Is there a way to do this? Report: Dashboard: Please let me know if there is a setting or something else I am missing! Thanks in advance!
-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…