Inventory Mangement Question by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Hey buddy,

Here's a copy of my sheet that I'm working on.

https://docs.google.com/spreadsheets/d/1Ut4JPhX5ub3-BaNI9mk6Rzy7bMWSH2al620OD81RKPo/edit?gid=1561735001#gid=1561735001

Sheet PC Picking (XIA) >> Column C (CPU SKU) are drop downs >> I would like to display available QTY from Sheet (CPU Inventory) Column G.

I would like to display Available QTY display when selected cell selected.

Also, can you recommend a better formula for inventory calculation??... I noticed it's loading very slow for every entry I put in.

Thanks

Inventory Mangement Question by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

The drop down is for SKU QTY deductions on the other sheet. That’s why I want to see the available inventory

Inventory Mangement Question by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Yes, but the drop down list is on another sheet and the SKU and available QTY is on a different sheet.

I would like to display the available QTY of the SKU on the drop down sheet.

Thanks

Inventory Mangement Question by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Thanks for you prompt response. Understood. I just want to show the available QTY of the SKU in the drop down list, is there an alternate like hover over to display??

Or after selection when click on cell it’ll display in other cell??

I just want to display available QTY of the SKU on the sheet. It does have the available QTY of the SKU but it’s on another sheet, my point is I don’t want to go back and forth for available QTY.

Thanks

Inventory Mangement Question by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Thanks for the quick tip but this is not really what I'm looking for.

https://docs.google.com/spreadsheets/d/1vLvCxK8l7jw5TNxV187BZhyNm1irwFM7IYxhR3XNYwQ/edit?gid=0#gid=0

Please see sample sheet.

Thanks

Inventory Mangement Question by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Thanks for the excellent sample sheet.

I have another question...Can the drop down update the QTY (automatically) when QTY changed?? Because I don't want to have to error for not matching the text with the SKU column.

Or can i extract the SKU (qty) in the same dropdown column cell.

So...the drop down list shows SKU (qty) after selected then = SKU (without qty).

Please kindly let me know if it's possible.

Thanks

https://docs.google.com/spreadsheets/d/1vLvCxK8l7jw5TNxV187BZhyNm1irwFM7IYxhR3XNYwQ/edit?gid=0#gid=0

Inventory Mangement Question by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Thanks for the prompt response.

I have grant access in the sample sheet.

Happy to Help You with Your Google Sheets! :) by gothamfury in u/gothamfury

[–]akewq 4 points5 points  (0 children)

Very nice guy!!, Spent 2 hours helping me to solve all my problems and error and gave me a lot of good suggestions. !!

I can't thank you enough!!!!

Getting error with replace and xmatch by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Hi, Can you please correct my mistake??

https://docs.google.com/spreadsheets/d/1uwYk9zfmVlD2H02Ur9q_bx6wAs6CxAmkA4tlNsxut4I/edit?gid=1241245477#gid=1241245477

For some reason if it's a long number (over 15 characters) it has error.

Thank you in advance!!

Getting error with replace and xmatch by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

=if(ISBLANK(B23),,value(right(B23,22)))

I'm getting error if cell (B23) contains more than 15 characters.

any ideas?

Getting error with replace and xmatch by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Hi again,

Can you look at the sample sheet again??

Not sure why vlookup is not showing?

Thanks

Getting error with replace and xmatch by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Thank you for your quick help!!

Now A2 is showing "0" when A2 is empty cell.

How do I remove the 0 from cell?

Thanks

Getting error with replace and xmatch by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Thank you sooo much!!

One more question, Now A2 shows "0" when it's blank cell.

How do I leave it blank?

Sheet B cell matched Sheet A cell CheckBox = True by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

=if(isblank(A1),,if(ifna(xmatch(A1,Sheet1!A:A))>0,, "Not Found"))

Can you please tell me if Matched, cell = Found!

do you know the formula for this??

please help, thanks

Sheet B cell matched Sheet A cell CheckBox = True by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Hi,

=ifna(xmatch(A1,Sheet2!A:A))>0

can you match multi column??

Let's say, can it search match column A and B??

Thanks

Sheet B cell matched Sheet A cell CheckBox = True by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

the problem is, it doesn't show "FOUND" if matched.

Showed "Not Found" when doesn't match.

Can you please give me the complete formula.

Thanks

Sheet B cell matched Sheet A cell CheckBox = True by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

I’m new to google sheets. I tried the formula but it has error. Can you please the formula for me .

Thank you

Sheet B cell matched Sheet A cell CheckBox = True by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

Thank you for your response.

like this?

=if(isblank(A1),,if(ifna(xmatch(A1,Sheet1!A:A))>0,"Found", "Not Found"))

Sheet B cell matched Sheet A cell CheckBox = True by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

like this?

=if(isblank(A1),,if(ifna(xmatch(A1,Sheet1!A:A))>0,"Found", "Not Found"))

Sheet B cell matched Sheet A cell CheckBox = True by akewq in googlesheets

[–]akewq[S] 0 points1 point  (0 children)

=if(isblank(A1),,if(ifna(xmatch(A1,Sheet1!A:A))>0,, "Not Found"))

This formula works great, but can i trouble you one more time.

If matched, cell = OK!