-
Line chart with multiple date-numbers traces
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I…
-
Date column formula to start on a specific date and continue on after that.
Hello, So I have a helper sheet that tracks total number of entries for each month in each year. Right now I have a formula set up that checks the date above, and depending on if the current month is past that month, it will automatically fill in a new line with the current month (Due to date formatting, I have it set that…
-
Dashboard, column cut
Dear all I have created this Dashboard from a report and on the first column (see picture) value/text is not shown completely - actually it should say LAUFEN. This BRAND column is not the primary column and the Align cell function is also not the reason why it's cut. In the report, the column is shown as it should be. I…
-
Hide Dynamic View name on Dashboard?
Is there a way to hide the dynamic view name, filter, show/hide formatting, wrap test buttons when you embed the view on a dashboard? Or change the format?
-
Transfer data from one sheet to another
I know SS has the "move to another sheet" or "copy to another sheet" but sadly it does not look like you can do that and have "cell links" from the blank form that you are going to copy data to , to do other items. Does anyone do any copy / pasting that is advanced and would have some suggestions? Here is what I am doing…
-
How to capture time elements from a form and display on a dashboard.
Good morning Experts, I have a particular set of data that is tracking productivity with a time element reported as (hour):(minutes) AM or PM I am gathering the data in a form using text/number. Once in the sheet/grid I cannot figure out If I can or how to auto populate the results for a single time element in my sheet…
-
Mass Edit in single dashboard
Hi, Is it possible to do a mass edit in the dashboard. I would like to delete a large group of individual objects, but so far, I can only do them one at a time. Is there a way to "ctrl shift" to select multiple objects for deletion? Thanks! John
-
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…