I have a people column. I need to add a calculated column that can give me the domain. This formula
=RIGHT([ReportTo],LEN([ReportTo])-FIND("\",[ReportTo])) gives me the name. But I need to get the domain so for contoso\dsmith will show contoso in the calculated column.
I was going to try this formula
=LEFT([ReportTo],INT(FIND("\",[ReportTo])-1)) but it looks like I can't use Person or Group type column in the calculated field. Any other suggestion on how to extract the domain name from person column?