-
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,
-
Old Links Resurfacing on Dashboard Despite Updates
In order to maintain a consistent dashboard design for various use cases, I used the "save as new" option, generating a fresh dashboard. To expedite the process, I repurposed some existing widgets by modifying links to correspond with new forms. However, despite my updates, I eventually received feedback from users…
-
Number of weeks countdown from today to start date
Hi! I've searched other threads and haven't found a formula that works for me. I'm trying to create a countdown in weeks for events on a sheet to pull into a dashboard. I want to display the number of weeks from today's date to the event start date. I tried this formula: =WEEKNUMBER(TODAY()) - WEEKNUMBER([Start Date]12)…
-
Help for Status Change and Tracking
I am trying to create dashboard widgets from data that I am tracking. For this widget I am wanting to have a graph show the number of people in each status section I have listed: "Not Started", "In Progress" and "Completed". Each employee has an individual sheet with tasks listed along with corresponding start/end dates,…
