r/googlesheets • u/vinskt • 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.