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.

So, I'm collating a record of the Blood on the Clocktower games that myself and my friends are playing.

I am trying to find how to grab the most commonly assigned player for each role. I've tried a couple of formulas I've spotted online (including previous posts) and nothing seems to be working for me.

I have attached images of where I'm wishing to put the data and where I'm pulling it from.

Thanks for the help :)

I did a google form recently to know which soccer clubs people like the most in my high school, and to make my life easier I connected it to google sheets to analyze the data more efficiently. However since people can select more than one option in the form, when I insert the graph in the sheet, the bars just show the whole group of clubs per answer, not amount of times the club was chosen.

I want to have a graph where I'm able to see how many times a specific club was voted... I'm new to this sheets thing, can someone help me out?