-
Formula to identify the task name of next child task due
I'm trying to get a formula to work that will show me, in a specified row, the Task Name of the child task that is due next. Formula: =IF(AND(COUNT(ANCESTORS([Task Name]@row)) > 0, isParent@row = 1), IF(COUNTIFS(CHILDREN(Status@row), "Complete") < COUNT(CHILDREN([Task Name]@row)), INDEX(COLLECT(CHILDREN([End Date]@row),…
-
Setting Up If Statement with 3 Parts
I have a status column where I want the 3 options to be "Not Started, Work in Progress, or Complete". The "Not Started" status would come from the Comments & Date Closed column being blank. The "Work in Progress" status would be based on there being comments added, but the Date Closed has not been filled in. The…
-
Countifs Multiple Criteria
I'm trying to count all the "Reserve" jobs for the year 2023. it's reporting 0. What am I doing wrong. =COUNTIFS({NEW SALES - DATABASE Range 2}, "Reserve", {NEW SALES - DATABASE Range 1}, (IFERROR(YEAR(@cell), 0) = 2023))
-
#UNPARSEABLE error in COUNTIF formula with OR function
Hello, I am unsure why this formula is returning #UNPARSEABLE. =COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Task List - Texas Projects PM Status}, @cell = "Red"))) It is supposed to count the number of times a name in the "FND…
-
Can you have two "OR" functions within a COUNTIFS formula?
I am trying to count a column based on data that is in two other columns. Each of those columns could have different information so I am trying to use a OR function but I am running into a couple roadblocks. Scenario: I want to count the row in column A if it equals "IT" and if column B equals "Apple or "Orange" and if…
-
#INCORRECT ARGUMENT SET error
Good afternoon, I have been getting #INCORRECT ARGUMENT SET error when using this formula: =IF(AND(Category@row = "Demo account"; [Custumised timeframe]@row = "No"); Submission@row + 30; ""; IF(Category@row = "Content contributor"; [Estimated Editing end date]@row; IF(AND(Category@row = "External supplier"; [Custumised…
-
COUNT IF + NOT CONTAIN
I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))
-
IF(OR) formula - add AND qualifier for all
I have an IF(OR) formula that is working exactly the way I want it to. I want it to check a box if one of three column criteria is met, which it is doing correctly, using the below formula: =IF(OR([Column A]@row = "Choice1", [Column B]@row = "Choice2", [Column C]@row = 1)), 1 I want to add a second condition that applies…
-
Formula for drop-down menu selections
=IF(CONTAINS([202-Disability,801- Offender,802 Low income,803ESL]@row, "Disability"), 1, 9) What changes need to be made to the above formula to return a "1" if "Disability" is selected, and a "9" if it is not selected--whether or not there are multiple selections made in the drop-down menu? This formula works when…
-
Conditional formatting, status balls don't change colour
Hi! I'm using this nested-if formula to automatically update the status ball: =IF([% Complete]@row < "70%"; "Red"; IF(AND([% Complete]@row >= "70%"; [% Complete]@row < "100%"); "Yellow"; IF([% Complete]@row = "100%"; "Green"))) The status ball, however, stays red for all rows, what am I doing wrong? The sheet can read the…
