hello I have a question, I have two table in appsheet, one for input and one for Data
table one (Data) consist of:
Material Name, Material Position, and Material Stock
table two (Input) consist of:
Material Name, Material Position, and Material Stock
I want to it to automatically input the material stock in the second table if the material name and position that I inputed matches the first table.
I tried using this formula but it is not applicable, any help??
LOOKUP(
[_THISROW].[ColumnA] & [_THISROW].[ColumnB],
'TableB',
'ColumnA' & 'ColumnB',
'ColumnC'
)
Write it like..
ANY(SELECT(Data[Material Stock],
AND(
[Material Name]=[_THISROW].[Material Name],
[Material Position]=[_THISROW].[Material Position]
)
))
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |