-
IF AND formula help !!! Please :o)
I have a formula which you guys helped with previous which after using for a few months need to tweek as it not quite working. So the formula is set to to change the status box depending on a set of rules and used for an internal audit planner. The issue; The formula is a little broken in that in order for the…
-
Count Ifs for multiple criteria
I want to count how many developers we have in a certain area based on two criteria, what team they are on and if they are onboarded. =COUNTIFS({US Digital Team Members Range 2} = "API", [{US Digital Team Members Range 1} = "Building Services & Analytics", {US Digital Team Members Range 3} = "Onboarded"], 0)
-
Auto-Number generated for parent/children rows
I am trying to build up a WBS and would like set a number generator to auto ID the various levels (control accounts and work packages). I would like to have the parent row, or control account, have an ID of 1.1 and the work packages, or child rows indented from there, to have an ID of 1.1.1, 1.1.2, 1.1.3, etc. Being a…
-
Problem with IF CONTAINS formula with multiple IF
I am trying to return a value of 1 through 26 based on the corresponding number in a column (Sprint column). It works when I just use one set, but not all of them. I realize this formula is huge so if there is a better way to do this, please feel free to suggest. The number convention of the column contains a value and…
-
Bring data from another sheet (Row data)
Great community! I need help to bring data from another sheet. If data is input vertically, then I can use countifs or sumifs, etc... but it is horizontally input. In the picture, I want to bring the number 100 (Purple) to Green square from the Sheet 2 to Sheet 1 , When customer name, product name , Year and Month is same…
-
column formular?
Hi Experts, I'm using this formula to calculate how many rounds I have done. =COUNTIFS(Season$1:Season@row, Season@row, [Dev Type (Article)]$1:[Dev Type (Article)]@row, [Dev Type (Article)]@row, Factory$1:Factory@row, Factory@row, [Article#]$1:[Article#]@row, [Article#]@row) It works, if I copy it in each new row, but I…
-
Auto number when box is checked
question on how to generate a number when a checkbox is checked. This seems simpler than other peoples asks, but I can't seem to make it work for me. screenshot is the area that needs to be addressed. I want the [PO #] (currently set to auto-number every row)to generate the next number ONLY when the [PO needed?] is…
-
Trying to return a value once, but not when cell value changes
Sorry I don't really know how to phrase this. Basically in the projects we have, we get a quote from a vendor, and they automatically enter it into our project sheets. Because this can change to a lower price or cancelled altogether we set up automation so our price column changes to the lower cost, or to zero if…
-
SUMIF after evaluating multiple Ranges
Does anyone know of a way to SUM a column in a sheet, after evaluating multiple other columns in another sheet to determine which column to sum? Essentially, I need something like an IF(SUMIF(..., but that isn't working for me. The formula below is currently working in SHEET B to only look at a single column in SHEET B to…
-
MIN (Collect) with multiple cross reference criteria?
Due to the 500k cell limitation, I have to break my source data up into multiple files. I am attempting to write a formula that looks for the MIN date across date columns in two files when the row includes the customer name. This is what I have and it isn't working. Would love some help. =MIN(COLLECT({sheet1-date},…
