-
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…
-
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…
-
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},…
-
IF(AND(NOT(ISBLANK Multiple Conditions?
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula with multiple "ANDS" If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column AND the Provisional Requested Amount is over 50000, I want the cell to say…
-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
-
Count formula
I am trying to create a formula where it will count how many rows are assigned to HR within a multi-selected row. HR may appear by itself or with another option. The multiple selected rows are throwing the count off and I cannot seem to figure out how to fix it. I tried using the CountM function, but it is counting…
-
IF(AND(NOT(ISBLANK Formula Trouble...
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula. If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have. =IF(AND(NOT(ISBLANK([Provisional Requested…
-
Referencing Another Sheet - VLOOKUP vs INDEX vs ??
Hello, I need to populate a cell with a number that is in another sheet based on an independent UID found in a different column that will be on both sheets. Not sure which direction to go on this -- For each line form-generated line, D. needs to look at C., find/match the data to A., then populate D with B when: A.…
-
Way to have multiple people claim an item
Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have multiple people be able to claim an item if there is Available Quantity left, as well as put…