Pull a value from another table based on a value in another column

AppSheet AppSheet Q&A
1

Hello,

i have 2 tables - 1 to track current stock and 2nd to track orders

So i create a row(order) in the second table with barcode from the first, quantity and status of the order.

I would like to see in my first table the currently ordered quantities from the second table, for orders where the status is “Open” (for example)

I guess it is a select formula, but will appriciate your help

2

Create a column on your Products table with the following expression:

SUM(SELECT(Orders[Quantity], AND([Status]=“Open”), [Barcode] = [THISROW].[Barcode]))

1 Like