-
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…
-
Can I count data that is saved in a report?
I have a report that collects data from many sheets and gives me an output and a date. I need to count how many are in that report for a given date. Is there any way to count instances of something occurring in a report rather than a sheet? It seems that this should be a function.
-
Count Netdays if Project Status is "Complete"
Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date", and "Actual End Date" I have a grid with 200+ projects/rows (Project Intake Sheet), and would like the formula to…
-
Is there a way to show a parent task on a row-sheet report?
I am creating a report, pulling from multiple sheets, that shows upcoming tasks in the next 7 days. The problem I am running into is that there is no hierarchy shown on the report. I get a list of tasks, but I do not know what 1) sheet they're from or 2) what phase/parent task they are related too. Is there a way to show…
-
How do I get Summary Totals to appear on the pdf attachment?
I love the enhanced report features with the grouping and summary totals. But when I send this as an attachment, they disappear? Is there a way to print and save the report to an attachment so that it presents the designed view? Thanks for your help! Sheila
-
Rolling 12-months formula: % of projects completed on time
I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-months will be based on the Actual Complete Date column. Below is is the data. So for the…
-
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…
-
Sheet Summary CountIFS + Date Range
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
Show top 10 schools on dashboard based on number of active students at each in datasheet
Been playing around for a while and haven't been able to sort....I have a datasheet with a bunch of data associated with a list of students, including the school they attend and whether they are currently active, graduated etc. I am looking to build a dashboard widget that shows the top X schools by count of active…
-
Gannt Chart in Dashboard
I have a dashboard that I've created that is pulling in a report that looks at key activities and dates from a project plan. It is a Gannt chart so users can get the visual of the project status. The problem I'm running into is that the Gantt chart is being displayed with the earliest date/data from the report. I scroll to…
