SharePoint Calculated Column with department from a People Field

Occasional Contributor

Hi all, 


I am a beginner in SharePoint online. I created a document library and created a people field called Raised_By. Now i need to create a calculated column to extract the department from Raised_By  so it is placed in the calculated field. 


When I am creating the calculated column in the list of fields there isn't Raised_By so I cannot create a formula based on this people field.  


Is there a way to do this?

0 Replies