-
COUNTIFS Using "OR"
Hello! I have two working formulas that counts my company's personnel based on specific criteria, but I'd like to use them in the same cell so that data is gathered if either of them are true. Here are the separate formulas: =COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Area FY23}, "East")…
-
Adding IF to a formula with IFERROR
I'm using the following formula (which works because you all helped me with it!) =IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), "") I need to add "if the "Deployment Complete" box is unchecked but have no idea where to put it in the formula. Thanks for your help!
-
Cell linking from one cell to a column on a different sheet?
Is there a formula that updates sheet 2's column when I enter data on sheet 1's row? ex) If a daily update starts on sheet 1 when the data is entered/attachment is attached, can a date automatically enter on sheet 2's date column? Sheet 2 is a running sheet so the date that I want automatically entered would be put once in…
-
Countifs Function with Two Coulmns
I am trying to create a function where it will count the number with specified criteria in one column as well as if 1 of 2 columns is not blank. I have the formula figured out where it will count 1 of those columns but cannot figure out how to add the "OR" piece so it will count data from column 2 only if column 1 is…
-
IFERROR Formula getting an error
This formula is giving me an "Incorrect Argument" error. =IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY(), "")) What am I missing? Thanks!
-
Help with formula for schedule health
Hello, looking for some help with calculating schedule health. I have added a symbols column (Green, yellow, red, gray circles) called schedule health to schedule. I have started creating a formula to calculate the schedule health for each row. This is what I have based the formula on: On Track = Green. Occurs when ‘%…
-
IF / AND / #INCORRECT ARGUMENT SET - Formula Help
I'm trying to assign a "Status" column of Not Started, In Progress, Overdue, Complete, or Not Applicable (if a box in another column is checked), and am getting an error of #INCORRECT ARGUMENT SET. Appreciate any help. I've spent way too much time on this. :-) =IF([% Complete]@row = 1, "Complete", IF([Task Not…
-
Auto Populate Children Dates based on the parent first day of the month
Good evening - I am looking to create an auto date that maxes based on the month (i.e. 28 days in February or 30 days in September) based on the parent row. I originally had it by calendar year and organized by the Month as the parent, and that parent row has several values that are linked to other sheets, however, I was…
-
IF/AND/OR Nested Health for Checkboxes
Thank you Community as I thought I had this from all your previous questions, but I am still receiving an Incorrect Argument Set error for this one. =IF(AND([Database Complete]@row, 1, [Enabled Interface]@row, 1, [Charges Flowing]@row, 1), "Green", IF(OR(AND([Database Complete]@row, 0, [Enabled Interface]@row, 0, [Charges…
-
Pre-chosen date based upon name chosen
Hey all. Is it possible to set template date(s) in a group of cells when another cell drop down is selected? For instance, If I choose from a drop down "June 2024" the dates cells next to this would snap to certain dates (milestones) automatically. Trying to have x4 milestone dates snap when a "Month Year" is selected. Can…
