I have a custom list with the following columns to track employee absences and coachings. This list is used by managers. Managers will enter details for an employee coaching session.
- Employee Name: Person or Group
- Discussion Type: Choice
- Discussion Date: Date and Time
- Discussion Comments: multiple lines of text
What I'm trying to do is create a list view that will only display items where the employee name is someone who reports to the manager viewing the list? Basically, if the Employee Name field contains a person that reports to me, display that item, if not, don't display that item. I've tried a variety of methods but all have come up short. I can't do
where created by = [Me], we move employees around a lot. I want to see entries for an employee that reports to me but maybe I've not entered an entry for that person yet.
I've scoured the internet and have had no luck. Any help you can provide would be greatly appreciated.