hi,
in sheet "order tracking" we fill all the orders column B:h are order columns. and from i:af are tasks which are being performed for completion of the order. row 2 is the person name by whom the task has to be done and row3 is which all task has to be done.
these orders takes completion in many steps. for example - if we 3rd row in order tracking which is homecity 4330-A. order quantity 2670.
these 2670 will not complete in one single process. this will complete in many colors and size. so it will turn in multiple sets of order which we called batch. these batches are located in sheet "batch tracking".
i want a formula in sheet "production summary" in b4 which all batches have not filled dates in column K. but one condition is that column s should be filled for that party name and po no.
i have applied formula in b4 in production summary which is showing result but it is including def 4514 which is not have date in column S in order tracking. so it should not reflect in production summary. i have highlighted this "row53 "in yellow color.
while xyz 4513 have date filled in s column of sheet "order tracking" and is included in "production summary" which is correct. because column K in batch tracking is blank after having date filled in S column of "order tracking"
please correct the formula as needed or any other solution.
if it is not possible in excel then here is the link of my google sheets file.
https://docs.google.com/spreadsheets...#gid=444280910
Bookmarks