Hello, I have been using Smartsheet for many years and have built many solutions. Over the past year, my role has been to develop solutions in Smartsheet as we've launched a new department. With a new…
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 in…
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…
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'. …
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 us…
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 …
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. …
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 man…