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. Ea…
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…
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 app…
Hi: I am trying to generate a sum (cumulative) of all effort "points" for projects started in the current year. CASE 1: My reference columns are: "Project Start" (date) and "Effort Count (Est. Total)"…
Hi, I have a sheet with active jobs, some are scheduled and some are not. I want the Sheet Summary field to show the furthest date listed, but some of the rows do not have a date in the selected date …
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate…
Hello - new user here! I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, dep…
Here is the situation: We have setup Control Center to build a project workspace from sheets. There are also several dashboards and a separate summary sheet. We are pulling information from the separa…
I'm working with the communication plan template and even though I changed the options in a drop down list, when I work on the sheet summary report, it only gives me the original options that were on …