-
IFERROR Formula Not Working
Good day, team. I have a formula that works as intended, which takes the latest row of children data and inputs that as the value. That formula is: =(INDEX(CHILDREN(), COUNT(CHILDREN()))) and produces the following results: However, if there is no data in the children cells it gives me an "Invalid Column Value" as shown…
-
Formula for excluding weekends for an end date
I have searched and attempted the WORKDAY formula without success. I have a schedule that populates from this source and we have columns as shown. to get the Est Finish Date i used formula =[Planned Install Date]@row + [Total Man Days]@row This worked great except we dont work weekends and i would prefer if we can show the…
-
Help with a SUMIF / TODAY Formula
Hi! I am trying to write a SUMIF formula that calculates four separate column values that is less than 7 days old. The below formula works, but I need to figure out how to add in the 3 other columns I need to include in the calculation. Column names: Motion Temp Total, Still Perm Total, Still Temp Total Any help would be…
-
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…