I need to build an app to track daily activity in one category for multiple users

I am doing a competition among friends for charity. Currently the plan is to give google sheets access to everyone so that they can update daily activity. Is there a way to build something like this in AppSheet? I would like a list of the names in one category and a total of their daily activity in the next category. ***Bonus would be to have a profile where you can look at history of activity of your fellow competitors.

Greg 150
Tom 175
Bill 200

Something as simple as this.
Then when I click on Greg’s “profile” it will show me his daily activity. Day 1 - 10, Day 2 - 15, Day 3 - 20. Etc and etc.