Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Formula for subtracting cell value from another sheet

874 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Gokul_Kumar
6 - Interface Innovator
6 - Interface Innovator
See Solution in Thread

‎Jul 22, 2016 08:42 AM

I have inventory and order sheets, lets say I have 5 no’s of item A and on entering new order on order sheet, quantity from inventory sheet should get subtracted.

I am not sure formula can be used with cell from another sheet.Currently I added count and subtracted from inventory quantity. But worried it may not be final solution.

Am I missing something? Kindly help me

Thanks

0 Kudos
Reply
2 Replies 2
Dean_Toland
6 - Interface Innovator
6 - Interface Innovator
See Solution in Thread

‎Jul 22, 2016 11:42 AM

I think the best option will be to use a column as a lookup to the sheet that has the info you want, then hide that field if you don’t want it visible on the new sheet. Then you can use a formula without having to point to other sheets or bases.

Reply
Gokul_Kumar
6 - Interface Innovator
6 - Interface Innovator
In response to Dean_Toland
See Solution in Thread

‎Jul 24, 2016 02:49 AM

Hi,
Thank you for the response

0 Kudos
Reply
Copyright © 2025 Khoros, LLC