I have an Excel spreadsheet that contains names and all work information-phone number, desk number, etc… which is an easy task importing it into a list BUT one of the columns is for vacation days so this makes it a bit more tricky to solve.
First issue: The customer wants the list to show each month
Solved: I imported the spreadsheet as a list and created a view for each month. This was the first issue I ran into. The best way to achieve this was to have a calculated column with workflows that automatically update the date for today. I set each months view to show if the following was true…
Question: Is there another way to show a list as a new month without changing the view? I do not want to make separate lists either.
Second issue: The customer wants to show the vacation days within the Roster
Solved (partially): There is one column called vacation date so I created another list as a calendar to show the vacation dates. I made a calendar view of the list. Then I overlayed the calendar with the list. When the vacation date is input into the list the info automatically shows on the calendar. To ensure customers do not have to switch between the list and calendar I created a link to the calendar and input into the list (column called link to vacation days).
Question: How do I create a way for the customers to ONLY use the list to input their work information and vacation days. I do not want to create more than one vacation date column. If a customer wants to take vacation say 1-10 October or 1 Oct, 5 Oct and 10 Oct how can they input this into the list without using more than one column or using the actual calendar?
