I want a split bill calculator based on multiple users

[Emma_Marslan]

The spreadsheet I have is set correctly, now I want to show points and percentages based on user input.

Example:

User 1 fills in how much they have paid for gas, tax, electricity, water and rent and now I want them to see how many points they have and percentage.

The point of the app is so flat mates see what parts of bills are paid in total

[ThinhDinh]

For the points, you can use a math column to sum all cols from Gas to Water.

For the percentage, first, make a rollup column on the points column to get the sum. Then make a math col, divide points by rollup total times 100 to get the percentage.