I’ll jump right to it.
I’m a novice in excel and appsheet and it all seems like a bit much so maybe I can find some help here.
Currently I’m working on a project that needs to be able to track assets.
I’ve created some actions that will look at one table (table A), grab the data, and place it in the proper column of a separate table (table B).
My problem is in the action that gathers all the values in the selected column, then Concatenates the results.
The formula I’m currently using is TableA[Column]
This is certainly incorrect but I think its a start.
So my question is, how can I filter the results so that I only get the value assigned to my asset number?