-
Sheet Summary - Why is the "Next" Button not showing up
Hi all - This may be a silly question, but I am trying to create a sheet summary report and when I go to select my source sheets the "Next" button isn't showing up (even when I scroll all the way down). I've attached a screenshot below. Has this happened to anyone else? Whatever help can be provided would be greatly…
-
How to center data in columns on report for dashboard
I have a sheet summary report for all my projects high level overview. I have the report on a dashboard. Its really bugging me the data is not centered on the report and subsequently the dashboard - how do I fix this?
-
Is it possible to set up a data shuttle from a sheet summary?
Hello! I have sheet summary formulas that collect various metrics on my data. The sheet / sheet summary is updated every time we attach a file to it (which is at least once every business day). I would like to capture the sheet summary metrics at a specific time interval - maybe once per week - and add them to a new row on…
-
Creating charts with multiple criteria without summary sheets and thousands of distinct formulas
I have a grid that contains an employee's level of expertise is a specific skill. There are 90 skills listed (columns) and around 50 employees. Each cell contains None, Beginner, Intermediate, or Expert. There are additional columns for each employee's name, department, and whether they are 'Active'. In order to create a…
-
How to create a chart of the sums of sheet summary fields from 2 different sheets?
I have 2 projects with sheet summary fields summing up the number of activities in different statuses (eg not started, in progress, completed). With a report I was able to pull this data together - I can even sum them up. What I cannot seem to be able to do though is create a chart based on the total row. Can anyone…
-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…
-
How to create a sum column formula in Sheet Summary
I have a formula base column that I'm trying to get the sum in Sheet Summary and I'm getting the #invalid operation error. I have some criteria for the sum I'm looking for and I did the exact formula for the [DDA Hours Used] column, so I'm not understanding why this one isn't working.
-
How can i make a row automatically get created and updated in one sheet as it is created elsewere
Hello world! I am trying to create a overview sheet that will be fetching values from two different lists. The two data sheets have a identifier number for each row in them, but placed in differant coloumns were only in one of the sheets is this identifier the Primary coloumn, so automating copy and paste row to other…
-
Count entries made the previous week
Hi, I am looking to create a sheet summary formula that will count all entries on a sheet that came from the previous week. I figure that it will have to be a countif formula and will incorporate weeknumber but I am lost on how to count from the previous week and have it keep updating for the next week.