-
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…
-
Convert decimals (fractions) to hours and minutes
Can anyone provide a simple formula to convert decimals/fractions to hours and minutes?