meetings

Hi I have a meeting I would like to ensure has all the required specialties in attendance to ensure the meeting is quorate to make decisions. So for example the meeting must have 2 surgeons, 1 nurse & 1 radiologist in attendance to be quorate (able to function). To check if each specialty is...

Hey all, I'm trying to find a formula that will help me with a project I'm doing. Im creating a meeting attendance record and am using checkboxes to check the person in the meeting. At the bottom of the sheet if they are supposed to be in a total of 5 meetings this month and only come to 3. I...

Hi I need a forumula for the following. In columns going left to right I've got dates populated, one day per column. On each of the Mondays (or Tuesday of the week, if that week had a Bank Holiday Monday!) there are target values showing that are the values that should be achieved at those...

I am struggling to find a way to solve the problem below and wondered if anyone has any ideas on the best way to solve this. I have a number of people, lets say 40 to start with, attending a meeting where there are 4 groups of 10 people. The goal is for the 40 people in the room, each will...

I have been looking around for an answer for a few days now and I can't seem to find anything close to what I am looking for. I am hoping you guys can either tell me if it is doable or not! What I want to achieve is select a name from a drop down list and show me all the items associated with...

Not sure how to phrase this - can I create a single-cell formula that knows what month it is and adjusts accordingly? Over a two-year period, the project team needs to hold a total of 52 meetings (with guidance to have 2 meetings each month with an additional 4 whenever). My spreadsheet lists...