Hi All,
First of all I want to say thank you. I've just registered today but your forum has being a big help so far!
I hope you want to help me with the following as I really don't know where to start..
I'm creating a sort of Break board tool where I need my colleagues to give certain breaks.
I've managed to create this but right now I want to check whether they already had a morning break or lunch or afternoon break.
-
My sheet is build up like this:
Sheet: Cover. Adds the break and shows who has a break etc.
When you add a break it will be added to the ''database'' as well.
Cell: B2 - Team Name
Cell: B3 - Persons Name
Cell: B4 - Type of break (Select: morning, lunch & afternoon)
Right now I'm stuck at this point.
The database is build up like this:
Column A: Name of the person
Column B: Date of today
Column C: Morning break (0 is none 1 is already had a break)
Column D: Lunch (0 is none 1 is already had a break)
Column E: Afternoon (0 is none 1 is already had a break)
So what I would like to do is when you add a break (Persons Name) add it to the database but if the personal already had a morning break it needs to tell me ''Person .... already had a morning break".
I hope this is clear enough. And I hope you are willing to help me!
Help is much appreciated.
First of all I want to say thank you. I've just registered today but your forum has being a big help so far!
I hope you want to help me with the following as I really don't know where to start..
I'm creating a sort of Break board tool where I need my colleagues to give certain breaks.
I've managed to create this but right now I want to check whether they already had a morning break or lunch or afternoon break.
-
My sheet is build up like this:
Sheet: Cover. Adds the break and shows who has a break etc.
When you add a break it will be added to the ''database'' as well.
Cell: B2 - Team Name
Cell: B3 - Persons Name
Cell: B4 - Type of break (Select: morning, lunch & afternoon)
Right now I'm stuck at this point.
The database is build up like this:
Column A: Name of the person
Column B: Date of today
Column C: Morning break (0 is none 1 is already had a break)
Column D: Lunch (0 is none 1 is already had a break)
Column E: Afternoon (0 is none 1 is already had a break)
So what I would like to do is when you add a break (Persons Name) add it to the database but if the personal already had a morning break it needs to tell me ''Person .... already had a morning break".
I hope this is clear enough. And I hope you are willing to help me!
Help is much appreciated.