Trouble linking some cells in Goggle spread sheets

Help & How To
#1

Hello,

my name is Jan and I am in need of some assistance regarding Google Spreadsheets and Glide apps in general.
:
I have a device that is sending some data to Sheets in this format:

image
image692×394 55.2 KB

And I also have a users sheet arranged like this:

And now my question is this how do I link up incoming data and the ID of a user to their balance cell in other sheets to match their id.

So, for example, incoming data in cell “Bill” is 10, and also incoming data in cell "ID " is 5 now I need to link the same ID in other “Users” sheet and subtract this incoming bill data from the balance cell so if the balance was 20 now it needs to be 10

I would much appreciate your help thanks

Jan

#2

In your glide data editor, you can create a multiple Relation column in the user table, that links the ID in the user table to the ID in your billing table. Then create a Rollup column that uses the relation to sum your bill amount for each ID. Finally, create a Math column that subtracts the rollup amount from the beginning balance. This will be your final balance.

1 Like