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:
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