Days Off
I need to show a list of employees available to work on a given date. I don't want to show employees available if they are on their days off.
Is there a way to look at today's date and determine if it has fallen on an employees day off if I provide the weekdays they are off?
Thank you.
Answers
-
Do you mean weekdays as in their shift schedule (ex. Monday, Wednesday, Friday) or days off as in specific holiday dates they have booked off?
There are some templates in the Solution Center built for tracking employee time off, see: Team Vacation Planner or Staff Plan Management template set.
If you just need to tell what day of the week they're working and if they're available on the selected date, you could set up a reference sheet that shows everyone's scheduled days, like so:
Then in the sheet where you're adding dates, you can use a Nested IF formula in a helper column to identify if the date you've added is Monday, or Tuesday etc, returning the same value you have in the chart above:
=IF(WEEKDAY(Date@row) = 1, "Su", IF(WEEKDAY(Date@row) = 2, "M", IF(WEEKDAY(Date@row) = 3, "T", IF(WEEKDAY(Date@row) = 4, "W", IF(WEEKDAY(Date@row) = 5, "Th", IF(WEEKDAY(Date@row) = 6, "F", IF(WEEKDAY(Date@row) = 7, "Sa")))))))
Then you can use whatever has been populated as the value to look for in the chart, and return all the Employee names that are available on that day of the week:
=JOIN(COLLECT({Employee Name}, {Work Days}, HAS(@cell, WeekDay@row)), ", ")
Is this what you were looking to do?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you for your suggestions. I don't know the solution yet, but this gives me some ideas to investigate.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!