-
Sum(Children()) and Sum(row:row) not totaling correctly
I created a sheet to itemize costs on furniture orders. I used a hierarchy so I could just use =sum(children()) to see the total costs of each project. While the first project totaled correctly, the second is coming up with an additional $2919.36. First I went back to ensure all of the figures are correct, and they are. I…
-
Return a list of cell values if one criteria is met
Hello, I would like to return a list of Project IDs (four digits) that meet the same criteria , so I went for : =JOIN(COLLECT({Project Summary MASTER Range Project}, {Project Summary MASTER Range Time}, "Yellow")) Unfortunately, it comes back as an 8/16/20 etc digit long without any separation - is there either 1) an other…
-
Creating a master budget file from multiple project budgets
I am trying to create a master budget file for tracking budgets and spending across several sheets, but I am struggling to come up with a solution that would enable me to drag the cell references across, like you can do in excel where it dynamically changes the cell reference. The sheets are structured with a budgetline…
-
How to use the COUNTIF formula when you have an OR statement that looks at multiple columns
I am trying to come up with a formula that will calculate how many tasks I have that are either "At Risk", which is a checkbox (flag) column, or has red health, which is a symbol column. I need a formula that does not add the totals of those conditions. For example, if a task is both At Risk and red health, I want that to…
-
Rolling previous 12 month count that spans into previous year.
I have a sheet that is logging customer complaint information. One column is recording the date of the complaint. One a second sheet I have 12 rows, one for current month, and one for each of the previous 12 months. I want that to automatically populate a cell in each of those 12 rows with a count of the total number of…
-
Metrics between Multiple Sheets
I have 2 Sheets that work together to track projects. Sheet A records the initial project for Group A. When the project is ready for Group B to take over, I have an automatic flow to copy the row over to Sheet B. They each have different milestones to reach. I need to gather a specific time between a completion date listed…
-
Receiving INCORRECT ARGUMENT SET when using an IFERROR
This is the error I'm receiving on my sheet summary page. Please note that the sheet is "set up" with columns and necessary formulas, there is just no information entered yet. Every time I open this sheet, I get the error above. To fix this problem, I just copy the formula, delete it, then re-paste it. This is after I…
-
IF And Formula Not Working
I am trying to check a box when a date is between two dates. I have a seperate sheet with a start and end column dates. It keep erroring out. =IF(AND([Punch Date]@row >= {StartDate}, [Punch Date]@row <= {EndDate}), 1, 0) Thanks for your help, Ron
-
Adding a Date require to IF statement
Hello, I'm looking for assistance in adding some criteria to this AVERAGEIF formula to make it so I am only averaging dates from this year. =AVERAGEIF({Completed - Department}, =[30 Day Post Release Quality Score - Segments]@row, {Completed - AQualityP30D}) There is no AVGIFS so I'm not sure how to appraoch this any…
-
Automatically add 1 to the previous value of a column?
Is there a function / automation that would add 1 to the previous value of a column? I am trying to automatically record the number of times that a date was changed in another column but can't think of how to combine formulas to do it.
