-
creating a pie chart of yes/no responses
Hi there, I have a smartsheet where 1 column is a yes/no column. I am trying to create a Dashboard with a pie chart that breaks down the percentage of yes responses and the percentage of no responses. I need some serious help, as I am getting a lot of error messages and cannot figure out where to even start.
-
Trying to get a dashboard to update with the most current entry.
I am building a weight loss dashboard for a client, that they can use for their clients. Everything is working how I want it to except for the current weight. I am trying to get that to update based off of the most current weigh-in weight that is added via the form. In the picture below it should be 180. I am trying a…
-
Cannot select data source for Chart widget?
Pretty sure this is user error on my part but I new to SmartSheet and can't figure it out. I am trying to add a chart widget to my dashboard that summarizes the number of overdue, in progress, etc. tasks. I am trying to select a Summary report as the source for the chart. When I select the report, the report appears all…
-
fixed durration vs. fixed start/end dates (deadlines) with gantt chart
I'm trying to develop a template for scheduling the 30 to 60 sub tasks in each of the many year long projects I'm managing. Im hoping to use a dashboard to tack all the projects at once. but for the template id like to set up an easily adjusted Gantt calendar. There are dates that are subject to fixed dates like quarterly…
-
Expand Parent tasks in Dashboard/Report
Hello I would like to ask about formula that will allow me to expand the Parent tasks in Dashboard view. Thank you in advance.
-
Dashboard Filtering
In excel I can build dashboards with a data drop down list that contains a list of areas, at the top of the dashboard and loads of graphs linked to it ... I have 2nd sheet (Data Summary) that has cell A2 =(Dashboard dropdown) to provide data, with formulas that data changes if it matches cell A2. (It all comes from a 3rd…
-
Track Birthdays and Anniversaries coming up
I am trying to set up a dashboard to allow me to see upcoming Birthdays and Anniversaries, with them being sorted to earliest upcoming being at the top of the list. I tried, what I thought would have been to do a min collect, without luck. Then I thought maybe someone had a better idea as to how to make the happen.
-
How can I auto-scroll a dashboard
Hello All I have a Dashboard (or report if I have to) that I display on a central TV. The idea of this is that anyone passing the TV will look at it and see any active tickets or high profile stats. On the dashboard I have a couple of widgets and reports that go below the TV screen. I am looking for a way to auto-scroll…
-
Dashboard / Report - Labeling
I am building a dashboard based off a report that was created from Sheet Summaries of 4 different sheets. The widget below shows 2020, 2021, 2022, and 2023 YTD. I would like for either the blue dot or the base of the column to reflect the year associated with the values. I am certain it must be somewhere earlier in the…
-
How do I get a dashboard to auto scroll down, up, and continue to repeat?
I have several dashboards developed that are longer in length than the monitor they are getting displayed on. I would like to have these dashboards auto scroll up and down repeatedly so that all the content is displayed at some point during a predefined time interval. Has anyone found a browser extension or a way to get…
