-
#UNPARSEABLE (Nested IF) - SOLVED
SOLVED! It was a DAU/Picnic error! I was missing the row number after the column name. Apologies, I'm not able to delete/close the original question. ________ I have a column named "Complexity". It's a drop-down list. The options in the drop down are: Rudimentary, Light, Intermediate, Advanced. Might you please shed some…
-
Can you use the COUNTIF function with another sum formula?
Hi I was wondering if someone might be able to help me please. I have a sheet that lists PPE items, i.e. Item, size, quantity taken etc. I have used COUNTIF to identity what has been taken using the following: =COUNTIFS(Item:Item, "hi-viz polo shirt", Quantity:Quantity, >0) Which returns the number of rows that have the…
-
Error with Multiple "IF" Statements.
Hi All, please could somebody help me with a "IF" / "OR" statement with two arguments, each argument with two conditions. Only one argument needs to be true to return a "1" or "Flag". Whenever I try include "OR" two separate the arguments, I get "Incorrect argument". At the moment, when one argument is true, the row…
-
COUNTIF using IFERROR and MONTHs
Hello, I'm trying to count a range of cells under the Due Date column in a referenced sheet when the dates have months of October, November or December. I saw another post about using IFERROR when experiencing Invalid Data Type which is what I experienced. The formula worked when I only counted for October (Month=10), but…
-
COUNTIF and CONTAINS and OR
I have 2 columns that have multiple select drop down options. I want to create a formula that allows me to identify a PLO and then count the number of times "BE" OR "BC" OR "BL" or "BM" appear throughout the entire sheet. so: =COUNTIF([PLO Alignment]:[PLO Alignment], CONTAINS("A.1 Environment",@cell), Sections:Sections,…
-
Applying complex formula to Column
Good day gurus, I need to apply multiple IF statements to a Column. Based on the choice made from a drop down menu, the result will return a number. The statement below works; however is not in the correct syntax for applying it to an entire column. I tried to use @Row but I am failing miserable as all my attempts are…
-
Formula to count total number of items selected in a column of multi-select fields
Hi, I have a column called Type, which I've set up as a multi-select drop down. I'm struggling with a formula to count all the items that have been selected. For example, they may have selected 4 responses on each row, but when I created the summary field to do the count on the column, it only gives me the number of rows…
-
Cross-sheet formula with checkbox
Hello all, I am trying to create a cross-sheet summary metrics sheet that counts data based on Status and whether a box is checked. If the "Project?" column check box is checked AND the Status is (for example) In Progress, I'd like this formula to count the number of instances. No matter what I try for the checkbox (true,…
-
Two date columns - need to take the earlier date of the two and add 10 years
Hello! I am hoping for some assistance with nailing down this formula so that it displays 10-years on top of the earlier date from two columns. I found a prior community post with the below formula, but I just can't seem to get it to work the way I want it to. =IF(AND(ISDATE([Last AF]@row), ISDATE([Last BIR]@row)),…
-
I need to calculate the networkdays between 2 fields including when the end date is blank.
Column 1 titled "todays date" - this is the date the item is submitted Column 2 titled "manager response date"- this is the date in which a response was provided Column 2 may be blank. - Therefore in this case I need a formula that will show me the networkdays from the "todays date" column and consider Column 2 as a 0…