-
Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
-
Removing widgets from dashboard view if access is not already granted
When creating a dashboard some widgets will be hidden for certain users. The outline of that specific widget (report) is then still visible with the message stating it is not accessible. The widget should not be there at all. This results in the dashboard looking incomplete and I do not want questions from the blocked…
-
Add a Button To Collapse Or Expand a Grouped Report in a Dashboard
It would be nice if we could have it both ways on a dashboard. It can be frustrating that you can't collapse a grouped report if the person that set it up set it up expanded and vice versa. There could be a button somewhere on the report that collapses all or expands all.
-
Integration of interactive maps into Smartsheet.EU
Hello everyone, I hope you are all doing well! We are currently looking for a way to integrate maps into Smartsheet.EU (based on a database of distribution partners managed in Smartsheet). The purpose would be to filter locations (e.g. by postcode) to get a quick overview of possible partners for a given area and to…
-
Average if when date is current year
we want to update the formula to show the average # of problem solving days when the idea is a JDI and the opportunity was submitted in the current year. Current formula - missing component to reflect only submissions from current year. =AVERAGEIF({APD CI Tracker Range 5}, ="JDI", {APD CI Tracker Range 4}) {APD CI Tracker…
-
Charts Plotting 0
I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values from showing on the chart. At this time the only solutions that we can provide would be…
-
SharePoint Permissions and Smartsheet Dashboard permissions
It would be great if there could be a way that a SharePoint permissions groups automatically translates to a Dashboard's sharing permissions list or even a Smartsheet Group outside of using an API (which I haven't even attempted yet). Basically, we want to share a dashboard on a SharePoint. This SharePoint is locked down…
-
Dashboard Custom Colors
I created custom colors for a dashboard. I'm now creating a style sheet to document the dashboard's colors, fonts, etc. How do I find the RGB color mixture for the custom color I created?
-
Referencing a Title Widget on another Sheet
I have a dashboard that shows a variety of metrics and data. We were previously using the formula MAX([Modified]:[Modified] to show the last update to the project plan. However, what we found was that any small change to the plan gave the impression that the dashboard was completely up to date, when there were still some…
-
How to aggregate sheet summary data into another sheet
Hello, I am currently working on developing a workspace to track system testing. The way the workspace is currently set up is having a summary level sheet that has each script, and then a folder per script. Within each script specific folder, there is a script summary sheet and a test script sheet. There can be multiple…
