Create an Inventory Management App Using Google AppSheet Part — 2

Step 1 : Add the Third Sheet

Step 2 : Calculate the Current Inventory for each Product

SUM(
SELECT(
Purchases[Quantity],
[Product Barcode] = [_THISROW].[Product Barcode]
)) -
SUM(
SELECT(
Sales[Quantity],
[Product Barcode] = [_THISROW].[Product Barcode]
)) +
[Initial Stock]

Step 4 : Display Restock Needed for Products having Low Current Stock

[Current Stock] <= [Restock Level]

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student. Created a course on Google Classroom

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store