-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
"mouse over" interaction on a dashboard
Idea: enable "mouse over" functionality on dashboards. For example, an explanatory field (black box) could be activated by a "mouse over" over an info field (i) (green circle). Example see screenshot
-
Provide a Image Gallery Widget in Dashboards
We use a Dashboard for a monthly Client report. The majority of the dashboard is text, tables, and graphs. We do insert an image at the bottom demonstrating progress on our construction projects. We would love to have a single "Gallery" widget, where we can load up to 10 images so that clients can scroll through the images…
-
Collapse Workspaces when searching for source report for dashboard report widget
Today, when adding the reports widget to the dashboard upon clicking for the source report user is presented with the dialog with all the reports across the Workspaces and this list is expanded by default making it difficult to scroll and look up (yes there is search but when you have reports with same name across folders…
-
How do I report cost changes?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…
-
Automated notification of Dashboard refresh
I would like to be able to send out to multiple people a refresh of the dashboard every month. Can't find a way to do that other than copying the dashboard link in an email manually. Anybody know if this simple function is available?
-
URLs for Templates
I have a few sheets that I saved as templates for other team members to use. I wanted to make the templates accessible from a dashboard by adding a shortcut to take users directly to the template preview so they can view it and choose to use the template.
-
Locking Monthly Dashboard Reports
Hi there, I am trying to find a way to "lock" a dashboard so that the reports do not refresh on the dashboard for a month. If this isn't possible are there any suggestions on how to create a monthly report utilizing the dashboard? Thanks!
-
Sorting by Grouped Status with a custom order
I'm working on a report that has the usual project status "On track, Paused, On hold, In Queue, Delayed Start" etc… I currently have a list of the project name as a line item, then grouped by applicable status. That said, when "sorting", it doesn't give me the option to see which goes at the top or at the bottom, and…
-
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error. =COUNTIFS({1. Case Queue Range 6},>"$99,000",<="$249,000")
