scummins22
New Member
- Joined
- May 3, 2018
- Messages
- 12
Ok, so I am creating an attendance sheet and I have it looking up the employee's # of points and letting it dictate by vlookup what level write up that employee is on. The catch is, if a employee has a no call no show they receive a point (like an absent) but also a right. Excel gives them the corresponding write up stage based off of the NCNS but when it gets to the next stage of write up it reverts back to the amount of points and does not stack the write ups like it should. I will give more detail below, can someone help me with this.
Amount of Points:
1-None
2-None
3-None
4- 1st Written
5- None
6- 2nd Written
7- None
8- Final Written
9- Termination
1st NCNS - 1st Written (1 point)
2nd NCNS - Final Written (1 point)
3rd NCNS - Termination (1 point)
so for example:
Jim Bob
Absent - 1 point
Absent - 2 points
NCNS- 3 points (1st Written)
Absent - 4 (Should be 2nd Written since employee received 1st written on the NCNS but it is giving me 1st written again)
What can I do to make this work?
Amount of Points:
1-None
2-None
3-None
4- 1st Written
5- None
6- 2nd Written
7- None
8- Final Written
9- Termination
1st NCNS - 1st Written (1 point)
2nd NCNS - Final Written (1 point)
3rd NCNS - Termination (1 point)
so for example:
Jim Bob
Absent - 1 point
Absent - 2 points
NCNS- 3 points (1st Written)
Absent - 4 (Should be 2nd Written since employee received 1st written on the NCNS but it is giving me 1st written again)
What can I do to make this work?