-
Chart Widget in Dashboard not separating data when creating charts.
I have a report that pulls in data from several sheets to summarize the yes and no columns. When I add the information to the chart widget I would like to see a group over group of 2 columns, one for Yes in this class and one for No in this class, and then see it class over class. Whenever I add the report to the chart, it…
-
Dashboard Chart Widget - changing series colour
Hi, I am trying to change the colour from Blue to Green, after following the below steps, I am still unable to see the change. chart widget pie & chart series change series select new colour ''green'' (changes from blue to green) save the colour changes back to blue Any idea why? Thanks,
-
Display Conditionally Formatted Data from an RSS Feed
Hello Community - I successfully created a SmartSheet that populates the Top Row with the most recent RSS feed data. This RSS data adds a new top row to my SmartSheet every hour. I created several formulas in the SmartSheet to display a conditionally formatted value (e.g. red, yellow, or green fill). I have about 10…
-
Create groups of widgets on dashboards
It would be very helpful for us if we could create "groups" of widgets on dashboards, and allow actions to be taken on a group. I'm thinking this would be similar to how grouping works in the microsoft projects. First you select all the widgets you want in the group, then you select an option to group them. Our primary use…
-
Have embedded report show collapsed by default on dashboard
Hello, I have a report that makes use of the new grouping functionality. I have it embedded on a dashboard (since use of the filters and grouping is not quite ready for prime time with the report app). Even if I collapse all of the groupings in the report before saving, it still renders as completely expanded when embedded…
-
Automate dashboard?
Dear SmartSheet Community, I hope this message finds you well. I'm reaching out to inquire about SmartSheet's capabilities for automating the creation of weekly and monthly reports. Our objective is to streamline our workflow by eliminating the need for manual report generation. We are particularly interested in:…
-
DASHBOARD SORT ON MOBILE??
Am I correct that there's no way to sort dashboards on mobile? I need things sorted by "end date" so I can quickly see what is coming due out of glance on my phone. If not a feature, that is very unfortunate since I was willing to pay for this product. If this feature is available I will buy this product - can someone…
-
Data Over Time Report/Dashboard
Hello, What steps should I take in creating a dashboard that includes a graph displaying data over time? I would love to be able to click on each data point and a pop up of that data point displays information during that time period. Here is an example of something I would like to create in Smartsheets
-
How to create a starting next/ending next box on the dashboard?
I am looking at a template from smartsheets, and I liked that they had a starting next and ending next box on the dashboard. Would I be able to set this up with tasks in a row in a sheet? If so, how can I set this up?
-
Average number of day formula
I have these two columns "Date Created" and "Date Closed". I need to write a formula that looks at all 1000+ rows of data and produces an average amount of days it takes to close a row of data. The formula will be in my calculations sheet. So, I'll be referencing this data. Should I use the "averageifs"? I really…
