Forum Discussion
Calculated Column to Return Email Address
tomhoffman Can you just make the 'Manager Responsible' a Person column so that the user has to choose from a full list of actual user accounts? Then you can send emails to them, no problem. I know sometimes users complain having to choose from the entire Active Directory listing (although I really don't understand why).
But failing that, I would try syntax like this:
=IF([Manager Responsible]="John Smith", "mailto:john.smith@email.com")I think you can just put a comma at the end and keep adding new IF statements. You'll just have to make sure you get the number of closing parentheses right at the end. If there are only a small handful of manager names, I guess this would work. But this method is limited and means you'll have to maintain it whenever managers change. Choosing from a Person column would be better!
tomhoffman This worked for me in a test:
=IF([Manager Responsible]="John Smith","john.smith@email.com",
IF([Manager Responsible]="Joe Jones","joe.jones@email.com",
IF([Manager Responsible]="Jane Doe","jane.doe@email.com")))So commas in between options, and close ALL parentheses at the very end. If I put in a Manager name that isn't accounted for in the calculated Email column, it just plugs the word No in there. But again, I recommend just making people choose from a Person column. Low maintenance for you!