-
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 -…
-
auto incremental's from form data
I am trying to make a column auto fill down based on the number in a column. So if column [# of Registers] shows 5. i would like the Register Hostname to populate out from USRETAMXT01 - Reg05 down the column.
-
Percentage of Child Rows with Check Mark
Hi, I'm trying to get a Percentage of Child Rows with Check Mark. Can anyone help out? =COUNTIF(CHILDREN(), 1) + "" returns the count of checked boxes. =(COUNT(CHILDREN(), 0) + "" returns the count of total rows, check or unchecked. So I divided the two, but I get #INVALID OPERATION error. Any thoughts?
-
Template and use of formulas
I am using a project plan template and have some formulas on the Health prebuilt - however if someonee adds another task via insert (which they should be able to do) it does not carry/maintain the formula on the newly added Health column. Please advise.