-
Sum of child rows multiplied by other row.
Hello Community, Can the sum of child rows that are individually multiplied be achieved without the use of a helper column? I would like to be able to detail the total sum of the child rows [March 2025] multiplied by [Rate] without the use of a helper column. I =SUM(CHILDREN([March 2025]@row ) * CHILDREN(Rate@row ))…
-
SUMIFS Formula with Dates
Having some issues with a formula to gather project budget metric data. I want to sum the values between a date range for each project. I get the invalid operation error on the formula: =SUMIFS({Cost}, [Primary Column]@row = {PrjNm}, {Date} < DATE(2024, 12, 31))
-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Countifs
OK - So I have a multi select cell with 4 choices (A B C D). I need to count only the cells that contain only both A & D. I tried countifs using and, contains but cant quite eliminate the counting of other combos for exampe ( A B D). Thanks in advance for any ideas.
-
Convert Created Date to Month/Date using Local Time
We have a "Audit date" column which collects the date and time when a row is added. That currently comes through as "6/30/25 5:15 PM". We have a formula that labels a Month / Year for reporting based on the "Created Date" column. That formula currently is =YEAR([Audit Date]@row ) + " / " + MONTH([Audit Date]@row ) This has…
-
SUMIFs Formula Help...
I am trying to calculate a specific persons total numbers across four columns in the Sheet Summary. Below is the formula that I have, but it keeps returning #Incorrect Argument Set. Please…what am I doing wrong. :) =SUMIFS([Motion Permanent Total]:[Motion Permanent Total], [Motion Temporary Total]:[Motion Temporary Total],…
-
Date reference and subtraction MM/YYYY
I am trying to reference a cell in the same sheet carrying today's date in MM/YYYY format using =MONTH(TODAY()) + "/" + YEAR(TODAY()). I need to keep an up to date month reference in the sheet for a span of a year. How do I rerence the "Today MM/YYYY" cell and subract a month from it while maintaining the same MM/YYYY…
-
Dropdown menu & how to separate results
I have a dropdown menu to select a choice of up to 19 out of a possible 42 items, each item selected needs to be separated into its own column as each selection is mapped. The way the mapping has been set up is the first selection in dropdown needs to be at position 1 even if it is the 4th option and the second selection…
-
On-call schedule communication
We have an On-call schedule in which Person A may be on call and ask persons B, C, D, and E to take over a shift. The On-call column is a contact email list. Persons B, C, D, and E will receive an Update Request to identify if they can cover that shift. Persons B and C respond that they can cover the shift. Person A will…
-
Formula Range
Hello Community, Is there a way to make the range for a formula start at a certain row and then continue on once other rows are created? I've found that leaving the end of range number blank or putting a future number row that has not been created causes the formula to be Unparseable.