Get the value from one column in another table

[Ahmad_1]

I have a column in the warehouse table
Column name "Balance"
In the inventory table there is a column named "Total"
I want to show the value of the "Balance" column in the "Total" column

[dbaum]

Does the Inventory table reference the Warehouse table? If so, try an expression like the following in the [Total] column's App formula property:

[Warehouse ID].[Balance]

Keep in mind that if [Total] is a data source column and not a virtual column, it will only update for a given row when that row is edited.

If you explain what need you're trying to fulfill, someone may have a suggestion for how to accomplish it differently.

[Steve]

LOOKUP() - AppSheet Help