-
Gantt colors and Dashboards - is there an easier way for my issue?
The issue I'm having is that I'm creating a milestone dashboard with gantt view, but need to be able to change the colors of the gantt chart, which can only be done in the grid sheet. Smartsheets does not allow for changing the gantt colors of lines that are considered headers, subheaders, etc. Only task lines. So now I'm…
-
Portfolio Dashboard - best way to showcase multiple phases within each project
Hello Community, We have multiple projects that are in not just ONE phase but have overlapping of phases within a project. We are trying to find a way to be able to display this in a visual representation? Not sure if we would filter out the full list of phases and only show key milestone phases? this is for development of…
-
Is it possible to conditionally format the colors on a bar chart?
I am tracking service level across clients. In the reports I get the formulas and conditional format to work but I can't get it to translate into my charts. Is it possible?
-
Ability/Function to view who edit the Dashboard widget last.
I ran into the situation when I updated Dashboard widget (and I was not the original creator for those widgets), other widgets which was on the dashboard lost the connection to the source sheet. I worked with SS Support desk and they told me because Dashboard widget has complicated permission setting on the widget. I asked…
-
Ability to hide/show grouping column name on report
I have came across two request in our company to remove rows with grouping name like in the example below"Parent Workstream" to save space and make reports more clean on dashboards. Please consider adding a feature to hide that information on dashboards.
-
Dashboard
Is there a maximum number of rows on the X or Y axis for a bar graph that can be shown on a Dashboard?
-
Merged: Dashboards - combo charts support
This discussion has been merged.
-
Calculate Average of Task Progress, per Person
Hello, I am trying to create a dashboard showing the average task completion status' of a number of team members. I feel this needs to be completed in Sheet Summary, but can't figure the right formula... Essentially trying to get; AVG of Column [Status], IF Assigned to [Joe] Any clues? thanks PS. the dark rows are parent…
-
Matching Neighbor Cells or Rows to Most Recent Date
Hey All, Background: Im trying to build a fluid dashboard that tracks information coming in from a form. This form is then routed to several sheets where I break it down further based on certain criteria. I am looking for a way to report on the most recent metrics in the given sheet using the sheet summary feature to make…
-
Sharing Qualitative Survey Results in Viewable Format
Hi All, I am looking for a way to display qualitative survey results in an easy-to-read format. Here's some background. Someone created a survey with over 10 open-ended questions and asked over 10 people to respond. This resulted in receiving over 100 unique responses. Some of the responses are as short as 5 words, but…
