-
Sheet Summary Formula Error
I am trying to create summary field on a sheet to show how many rows contain a users name. The summary formula is as follows: =COUNTIF(VP:VP, FIND("a user name", LOWER(@cell)) > 0) This works fine when the column VP contains actual values with text. However, if I put in a column formula to calculate their name from a…
-
How to sum up a number of values with widgets
So I'm looking to create a widget that quickly shows me the number of times a value is represented. What I want to do is separate out a number of teams I have and see how many times each team has a "missing" value in it. I have rows broken down by team members. There's multiple columns, but their team name is one of them,…
-
Chart widget functioning wierd...
I have a report showing calculated numbers in 3 columns. The numbers come from the summary sheets on various project files. Other than the sheet name these are the only columns in the report. Trying to use the pie and donut charts it says they are not available for this data set. Trying to select the columns it only shows…
-
Summary Report not displaying additional columns
I'm trying to create Summary Reports but only ever receive the created date/name, modified date/name and sheet name columns to select from to add to the report. I've tried saving and going back in but no luck. The sheets I'm selecting all have the same column names as they were duplicated with the save as new function.…
-
Summing a summary sheet report
Hi all, I have built a sheet summary report, and this is showing the data that I would expect. I would like to be able to sum each column - (i.e. one of the columns is no of reports that are live) so that I can get a total, and to put this on a Dashboard either as a Metric or have 5 or 6 columns combined in a chart. Sorry…
-
Is there a way to copy Summary Fields to other sheets but not overwrite data already entered
HI, I have an issue where we have most Summary Fields that contain formulas but we have a few which are keyed in for integration with our CRM. I have created a sheet with the manual summary fields and another for formula fields but when I copy only the last set of Summary fields are stored. Additionally, when we add more…
-
Is there a way to use a CountIF formula that would ignore hidden rows/cells?
Hello, I am am trying to create a summary report that would count the number of "complete", "not started", and "In Progress" with only using the rows/cells that are filtered. I do not need to count the rows/cells that are hidden but when I use the COUNTIF function, it would also count the hidden rows/cells. Thank you.
-
Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
Hi, I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A. I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet…
-
How do I create a summary page or report from a Financial Donor List?
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and the total amount they have donated. Also, is there a way for a new donor to…
-
Sheet Summary - SUM Chilldren Rows based on Status and Dates
Good Afternoon! I am trying to sum children rows where certain status' exist where the Pick-Up Date is today, within the next two days, and in the future beyond that. (Really, 3 formulas). I tried applying the following formula before involving dates to make sure the first part of logic is correct but it is giving me an…
