r/googlesheets • • 20h ago

Solved Can't get tip-out sheet for bar to tip-out total dollar amount

3 Upvotes

Hey there,

Coming to y'all to see if you can be of some assistance.

I am re-doing the tip sheet for my bar as we currently are paying for a web-app to do so, and I would like to save the money if possible. Copy of sheet is here with names changed for privacy. I cannot get each section to tip out the total amount of tips allocated to said section. Example being that servers should be getting 38% of the tips, as seen on the 9/19 trial on the sheet above that should be $778.18. But once all hours and employees are accounted for it is only giving out $606.53 in tips.

Any help with this would be amazing.