-
Multi-Project Dashboards
I'm maintaining some multi-project dashboards and running into some problems with dynamic cells. Currently we have "Metrics" documents for each project. These documents contain cells that link to our timeline documents. For example: A cell may contain Phase I Health Status - and the cell value links to the Phase I health…
-
Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],…
-
Need to Tally and List Unique Values From a Drop-Down
Hello, I have a sheet in which I am tracking distributor complaints. I need to make a few different graphs. One of which is supposed to be a line/tally graph of how many complaints have been made by each distributor. We have a list of almost 40 different distributors which we have in a drop-down select form, for the ease…
-
Client facing dashboard
I'm working on a client facing dashboard, that the client would put information in. From what I can tell this is not going to be pretty from the clients side. I have to share the dashboard. I have to share the report I created that is on the dashboard. I have to share the original sheet that the report above is created…
-
What is this widget and how do I create the same?
Hi, I was in a meeting with an external team today who used a dashboard to show Open tasks. In the widget, a user could drill down into the widget and add/view comments without having to click through to the origin sheet. Does anyone know how I can replicate this please? Many thanks
-
Surface row report data to dashbord
Is there a way to surface a contact from a row report to a dashboard? When I go to add using a metric the row report is not accessible. I note that the row report is accessible to surface data for a chart. What am I missing/not doing?
-
Duplicate Dashboard but with Date Filter
Hi, I am looking for ideas on creating a filter for date ranges in a dashboard. I want users to view the available data in a dashboard by quarter (three months of data). I have a dashboard built that contains all of the data for 2021 that is fed from a single sheet. I intended to continue adding rows to the same sheet for…
-
How to make a sheet that only shows the last x entries of another sheet
Hello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am running into troubles. For the line graph widget, they would like it to show the last…
-
Dashboard chart from sheet
Hi all, I am trying to create a dashboard chart widget on my RAG status. I have used the symbols in the sheets (Red, Amber, Green, Blue. However, when selecting this data via the widget, I get the following message "the selected columns cannot be charted...." Any advice if I can do this or it just isn't with the…
-
Question on Dashboards
I am trying to create a graph on my dashboard that shows a month by month historical trend line graph. When I try and graph out the info it sorts the months by alphabetical order rather than in the correct order. I have 2 columns on my source sheet pulled into a report one that shows the date an item was entered and I have…
