Need to find fillers and manufacturers of soups and sauces in the United States that are using metal cans. Can sizes we want to sell are 19oz, 14.5oz, 10oz and 9oz. These would be empty cans that are FDA certified and ready for food products. Both standard cans that need to be opened with a can opener and EZ off cans with a pull top.
The scope of work: Create Form Assembly form prepopulated with prime contract information from Salesforce. The form is to be sent to prime contractors to enter subcontract data for their contracts. Each prime contractor can have more than one contract. Each prime contract can have more than one subcontract. Data entered by prime contractors will be saved in Google spreadsheet or downloaded manually from Form Assembly in csv file
Why are these formulae not returning the same result when they should (multi-criteria met)? =if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH($A9,FP$4:FP8,0),1),IFNA(index($A10:$A204,MATCH(true,'3. Sorted by Density'!FP10:FP205,0)),"ORPHAN"))) vs =if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH(1,($A9=FP$4:FP8)*(FW:FW=FW9),0),1),IFNA(index($A10:$A204,MATCH(0,(true='3. Sorted by Density'!FP10:FP205)*(FW:FW=FW9),0)),"ORPHAN")))
I have two lists: - a bill of material showing with the following columns: product code, drawing no., qty - a list of product with the following columns: product code, delivery date first lot, qty lot 1, delivery date lot 2, qty lot 2 I need to allocate the product of the second list to the drawings of the first list, showing the latest date of reception of material for each drawing .