Sending data to google sheets using glide app_2

I am using glide app to submit data in google sheet. I want data to send by multiple users. each user is assigned a specific column or columns. Then in the google sheet, data in one column should not be affected by the data in the other columns ( issue of last row) . after all users have summited their work, I need to get totals in another column but in the same sheet. I therefore kindly ask for assistance. This link takes you a video to have a more clear picture of my issues. Thanks in advance.
Clip1 - YouTube

Please try to keep the conversation in one thread instead of creating multiple threads. This will make it easier to keep track