StephenM123
New Member
- Joined
- Apr 19, 2019
- Messages
- 8
Afternoon all,
I'm looking for a bit of help on the following.
I've had a search through the forums but haven't been able to find what I'm after so I'm maybe looking for the wrong thing altogether.
I would like to create some sort of custom calendar, using only formula from a list of data, extract provided below.
The list currently extends some 1000 rows and will continue to expand.
<colgroup><col style="mso-width-source:userset;mso-width-alt:6400;width:131pt" width="175"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
What I would ideally like to be able to do is pull a list of which employee is off on each day in to something similar to the format below.
I'm really struggling with how I pick up the next 'employee name' value in the lists.
<colgroup><col span="5"></colgroup><tbody>
</tbody>
Ideally after this I would like to split it out by if they work day shift or night shift as well but I should hopefully be able to do that once I get started.
Any helps on what I'm looking for would be greatly appreciated.
Thank you!
I'm looking for a bit of help on the following.
I've had a search through the forums but haven't been able to find what I'm after so I'm maybe looking for the wrong thing altogether.
I would like to create some sort of custom calendar, using only formula from a list of data, extract provided below.
The list currently extends some 1000 rows and will continue to expand.
Employee Name | Department Name | Status | Date | Hours | Process | Day/Night | Business | Week | Year |
Employee 1 | Out | Active | 10/03/2019 | 10 | Production | Days | Pogs | 11 | 2019 |
Employee 2 | Out | Active | 11/03/2019 | 10 | Production | Nights | Tazo | 11 | 2019 |
Employee 3 | Out | Active | 12/03/2019 | 10 | Production | Days | Pogs | 11 | 2019 |
Employee 3 | Out | Active | 13/03/2019 | 10 | Production | Days | Pogs | 11 | 2019 |
Employee 4 | Out | Active | 10/03/2019 | 10 | Production | Days | Pogs | 11 | 2019 |
Employee 5 | Out | Active | 11/03/2019 | 10 | Production | Nights | Pogs | 11 | 2019 |
Employee 6 | Out | Active | 10/03/2019 | 10 | Production | Days | Pogs | 11 | 2019 |
Employee 7 | Out | Active | 11/03/2019 | 10 | Production | Days | Tazo | 11 | 2019 |
Employee 7 | Out | Active | 12/03/2019 | 10 | Production | Days | Tazo | 11 | 2019 |
Employee 7 | Out | Active | 13/03/2019 | 10 | Production | Days | Tazo | 11 | 2019 |
Employee 8 | Out | Active | 17/03/2019 | 10 | Production | Days | Tazo | 12 | 2019 |
Employee 9 | Out | Active | 10/03/2019 | 3 | Production | Nights | Tazo | 11 | 2019 |
Employee 10 | Out | Active | 10/03/2019 | 10 | Production | Nights | Tazo | 11 | 2019 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:6400;width:131pt" width="175"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
What I would ideally like to be able to do is pull a list of which employee is off on each day in to something similar to the format below.
I'm really struggling with how I pick up the next 'employee name' value in the lists.
10/03/2019 | 11/03/2019 | 12/03/2019 | ||
Employee 1 | Employee 2 | Employee 3 | ||
Employee 4 | Employee 5 | Employee 7 | ||
Employee 6 | Employee 7 | |||
Employee 9 | ||||
Employee10 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>
Ideally after this I would like to split it out by if they work day shift or night shift as well but I should hopefully be able to do that once I get started.
Any helps on what I'm looking for would be greatly appreciated.
Thank you!