-
COUNTIF Checkbox Help!
Help!!! I'm trying to create a formula that counts a row if a column "A" value =X AND column B check box is checked. I have tried the following and it does not work. Any suggestions? =COUNTIF(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for…
-
Formula help - identify multiple WBS (predecessors) based on matching entry and dates.
I'm needing help finding a formula that will accomplish the following: Allowing PMs to enter WBS numbers into a column that that row is dependent on. They would need to be able to enter multiple possibly. This formula would then look at the Working Planned Start and end dates of those WBS rows and if that end date happens…
-
Column Formula to Average several other adjacent columns
I am trying to set up a survey sheet that gathers data through a form to have a constant formula in a column "Average Score". I can't find any specifics about how to build the formula only that referencing specific cells is not allowed. Here is my current formula =AVG([Overall Support]3:Improvements3) I know it needs to be…
-
Countifs with Column Formulas
I need a formula that will count if a course is completed and the month, for example =COUNTIFS(Month:Month, ="October", Status:Status, ="completed") This is returning the correct information. But, I am using a column formula for the Month and the COUNTIFS formula only works if the column formula is removed. Once I convert…
-
Populate Q1, Q2, Q3 etc as per Start date and End Date
Hi Team, I have below 2 requirements - 1) Populate Q1, Q2 Q3 etc as per Start date and End Date, I am using the below formula but it is giving error =IF(AND([Quarter Start Date]@row >= DATE(2020, 8, 1), [Quarter Start Date]@row <= DATE(2020, 10, 31), "Q1'21", IF(AND([Quarter Start Date]@row >= DATE(2020, 11, 1), [Quarter…
-
#DivideBYZero
Good morning, I have this formula that is displaying this error as noting is filled out yet in the columns How to I not get this error and just have a 0 or leave it blank so it does not look bad? Thank you =SUM(BAE@row / (([HRS/Day]@row) * [Crew Size]@row))
-
COUNTIFS from multi-select drop down
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works great since it is automated once the @row are filled in by my Team: =COUNTIFS({Planning sheet Range 2}, PA@row, {Planning…
-
Cross Sheet reference involving dates shows INVALID DATA TYPE
I am working on some inventory check and report. Inventory sheet as follows: Metric sheet to report on monthly incoming by items and month as follows: I am trying to refer to the Inventory Sheet to sum Qty In if: 1) Level is 1 (I don't want the parent row to be calculated) 2) Equipment Description matches the primary…
-
NETWORKDAY(S) not working for me
Hi - any idea why I am not able to get a formula NETWORKDAYS working? I've have below columns where due date and start date converted having formulas to get those dates. The formula is just "MID" combination and both columns are set to "date" format. I tried using different ways of NETWORKDAY(S) but I am only getting…
-
Formula Returns Blank Result
Hi all, Please can someone help. I have a formula that has worked every day up until today (Thursday). Can anyone spot what I am doing wrong? =IF(WEEKDAY(TODAY()) = 2, COUNTIF({Date Received}, TODAY(-3)), IF(WEEKDAY(TODAY()) = 1, COUNTIF({Date Received}, TODAY(-2)), IF(WEEKDAY(TODAY()) = 7, COUNTIF({Date Received},…