I've been out of the Sharepoint game for a few years, but the company I work for now has a need for a sharepoint site (and I'm the one to create it). I'm not a programmer and I've just recently installed designer, however my knowledge is limited there. So any guidance is appreciated.
I've created a team calendar, that is used to show various events, as well as show employee time off. What I'd like to do, is have only the employee time off requests require approval prior to showing on the calendar. Each new item is categorized by a choice dropdown column (OFF, Schedule Change, Meeting, Conference, Other). The OFF & Schedule Change categories are what need approval.
The other part to this is that people need to have those requests approved by specific supervisors (Example: Joe & Lisa report to Deb (she needs to approve), whereas Bob & Gina report to Nancy (she needs to approve).
Because only two categories need approval, I don't want to create a new column that will be applicable to all categories. I was trying to think of a way to create a calculated column that would populate only based on those two categories being selected, but I can't find a way to have a calculated column produce a people/group lookup (that would allow the user to select their supervisor).
I was hoping to get some suggestions on the best way to achieve this or another workaround altogether, while still using one team calendar.