I am new to SharePoint Lists and trying to create a workflow for only 1 of 3 lists on my site. I want this workflow to kick out an email when a new item is added to the list or a current item is updated to the list. The kicker is, I would like the approval email to go to a specific person based on one of the columns.
For example: The 5th column has multiple choice answers. If Column5= A, then an email goes to Joe; If Column5= B, then an email goes to Mary, If Column5= C, then an email goes to Mike, etc...
I have the list setup with permissions to show pending when changes are made or items are added, but trying to get a workflow so managers know when an item in their area is added and pending without being alerted on every item. I have watched about a hundred YouTube videos and have read multiple blogs, and they are either too basic, or too detailed. Can someone help?!