-
Countifs + Contains or Find Formula Help
I require assistance please to create a formula based on two criteria: COUNT "SPI Quoted Value" column, when >0 and when "Date" column CONTAINS or FIND "January" Therefore if I only selected the first six rows as example, the SPI Quantity cell would return the value of 4. I tried this formula, however didn't work…
-
How do I include Contact List Columns in Concatenation?
I need to create a primary key on a page that includes 3 text columns and 1 contact list. The formula errors when I try to include the contact list, but works fine without it. Is there a way to reference a contact column as text or get it to just read the name in the contact for that cell as text?
-
Using IF Statement & DATE
I'm trying to combine formulas that if a check box is clicked, it returns the number 7 to me or else it runs a formula for subtracting dates from TODAY but unfortunately I keep getting #INVALID DATA TYPE =IF(OR(COMPLETE@row, "7"), (TODAY() - DATE@row)) Any help would be great appreciated. Thanks.
-
Nested Ifs
I need and if statement on a metric sheet that counts if 3 criteria are met. If one column = this If another column = that If last column = "No" This is what I have and I though it might work but I get the #UNPARSEABLE error. =COUNTIFS({Range 1}, [Primary Column]3, FIND(AND({Range 3} = [Primary Column]9, {Range 2} "No")))…
-
Creating a widget
Hi, I need assistance in creating a widget for a dashboard. So basically I have got a sheet with close to 2000 rows and each of those rows have action owners, due dates, etc. I would like to create a widget that would show when the actions are due and who the action owners are (action owners vs due date). Can anyone…
-
COUNTIFS with Cross-sheet references
I'm trying to get a count of rows between two dates AND where we have the status as one of three choices. I've tried using the OR logic embedded in the COUNTIFS formula, but I couldn't get that working. Instead, I created a helper column next to status called 'Concluded' to evaluate whether or not the ticket's current…
-
Need help with a IF(OR) formula
I have the "base" formula correct and working but can't figure out how to string it together (are there best practices in this area?) with a larger formula: This piece works: =IF(OR([Go Live Month]@row = "January", [Go Live Month]@row = "February", [Go Live Month]@row = "March"), "Q120") I want to add conditions for the…
-
SUMIFS with multiple criteria in multiple columns
Hi - I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I try I either get an error. Here is the formula I have so far (which is wrong -…
-
Formula to check a box when date entered + 2 days
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. This is the formula…
-
Health RGY Formula
Hello All, Our team has created the below formula which worked UNTIL we added the bolded part below. We cannot figure out what is missing and we keep getting an #Incorrect Argument Set error when we change the End Date to be anywhere between that 10 & 30 day range. =IF(AND(Status@row = "In Progress", [End Date]@row -…