-
Enable Single Line Breaks in Dashboard's Rich Text Widget
Unless I'm mistaken, I am only able to make full paragraph line breaks in the Rich Text Widget. I've tried Shift, Ctrl and Alt along with Enter (Ctrl and Alt don't create any line breaks). It would be super helpful to have the flexibility to include a <br> style line break in addition to a <p> style line break. On a…
-
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…
