Dear team
I would like to if any formula can be defined to assign the staff to picke the items. I need to set the limit for each picker to pick 1000 qty in a day. If the qtys are more than 1000,the picker column should have a formula to asdign assign next picker. Please guide me.
Zone Order No. Order qty Picker
1 1 1000. Picker 1 Formula help is required
1 2 500 Picker 2
2 3 500 Picker 2
1 4 250 Picker 3
2 5 250 Picker 3
3 6 250 Picker 3
4 7 250 Picker 3
Last edited by ravisankarmariappan; 02-15-2019 at 04:42 PM.
The following formula in D2 and copied down reproduces your desired results:
Formula:
Please Login or Register to view this content.
However, what if C3 is 999 and C4 is 999 then Picker-2 gets to do almost 2000?
pickers.png
Hi
Thank you!
It can be up and down 2000 qtys bassd on the order size.
If 1 order consists 900 pcs and other order consists 900 it can be assigned 2 pickers.
If an order consists 1200 qty and other order is 800 pcs, 2 pickers will be assigned
BTW: welcome to the forum!
I think you are saying that there are cases where my solution is not working as desired. Correct?
If so can you please expand your post #1 table by adding the cases that are not currently working along with your expected results (picker number).
It would help a bit if you provided this information as a workbook - that will save retyping your data.
To attach a file, first make sure to remove any sensitive/proprietary data and then click on “GO ADVANCED” and then scroll down to “Manage Attachments” to open the upload window. Choose your file then click on “Upload”, scroll down then click on “Close this window”, then “Submit reply”.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks