-
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…
-
How to combine multiple sheets with large volume of data
I have a large data set (9K rows + 250 columns) so it is broken up into multiple worksheets. Is there a way to combine? I have figured out how to build reports on multiple sheets, but not how to compile the results for a dashboard (ex: count how many records are across all sheets and have this on dashboard with a breakdown…
-
Dashboard Metric Widget - Can you add a total from a sheet on the title?
Hello everyone, I am trying to see if its possible on the the widget to add a SUM from a sheet to the dashboard to be able to see the over SQM of a component of a project. I didnt want to add a line at the bottom of the displaying graph , wanted to show up top , is that possible or not?
-
SmartSheet bar at top of dashboard
I've created a dashboard that I use in SmartSheet and have embedded in our project's SharePoint site. Unfortunately, at the top is has our logo but the background color behind it is so dark, parts of it blend in. (see image below) Is there any way to change this? I've gone to Personal Colors& Logo but it only changed it…
-
What is the best way to move specific cell/column data when a specified trigger is met?
Customer example is that when information is added to the new order sheet, and marketing lead is assigned, and marketing deadline is populated, there are 5 columns of information that only need copied to the target sheet once the trigger is reached. The source sheet is 50+ columns. We don't want all columns. We've tried…
-
Merged: Combination Chart
This discussion has been merged.
-
Merged: Allow dashboards to open links in new tabs to keep dashboards open and improve time efficie…
This discussion has been merged.
-
Keep the scale the axis to max value
Hello, Any idea on how to remove the 150% and just keep the scale to 100%? Thanks,
