-
How to create health columns individually in a dash board ? using donut chart or Pie chart?
here is the data which I had in the summary sheet. can anyone please help to create a dash board with individual health charts?
-
Formula for counting if cell has RYG symbol
I need to count the total number of cells within a column if they have either Red, Yellow, or Green symbol. We also have the grey symbol, but that should not be counted. I am using this as a way to indicate the total number of active projects in our dashboard. I have tried =COUNTIF(Status:Status, "Green") OR(Status:Status,…
-
Does anyone have a simple RFP Scorecard Template they can share?
Hello everyone, I am hoping someone out here can help me. I need a simple RFP scorecard template. Has anyone developed one that they can share?
-
I Cant seem to get my gif work on a smartsheet dashboard
I like the design of the smart sheet PMO dashboard setup(link below) and attempted to design a replica for my solution but have not been able to figure out the gif part. After converting my video to a GIF and ensuring that the size is below 30 MB I attach it to the dashboard but it doesn't animate. how can I go about this…
-
Dashboard - Creating a Chart issues
Hello! I am attempting to create a chart within a Dashboard using the Chart Widget and when I select my data, I keep getting the error 'Selected data could not be charted. Please select a new range'. It doesn't seem to matter what data I select, it will not let me select it to create a Chart. Anyone have any insight on…
-
Saving default colours for dashboard widget graphs
I 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 of a template set equivalent. Is it possible to "pre configure" the graph to use specific…
-
Gantt View on a Dashboard - issues with Gantt showing data accurately.
When using a Report to pull data from a Sheet, the report allows you to configure the Gannt in various was (day/week/quarter, etc). When displaying the Report on the DB, and wanting to view a part of the Data, and the Gantt at the same the ---> the Gantt isn't proper. Ou use-case is shipping goods measuring Pickup Date to…
-
Dashboard is not opening Report Gaant chart to Todays Date?
Hi everyone! I have a Dashboard that is displaying a single report, which displays a Grid & Gaant chart. I need the dashboard to autorefresh regularly, but also show the Gaant chart from todays date. I do not see a way to achieve this with a dashboard - only within a report or sheet. Thanks, Simon
-
Frustrated
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
-
How to create a dashboard metric widget to automatically obtain the data template？
Dear friends, I am using the dashboard metric widget to obtain data, but I have not found a way to reuse it, it cannot use functions. I can create a new project form through a template, but when I use the dashboard, I have to re-select the data source. To obtain data for a new project, is there any good method to suggest…
