SharePoint Calculated Column with department from a People Field

%3CLINGO-SUB%20id%3D%22lingo-sub-1723152%22%20slang%3D%22en-US%22%3ESharePoint%20Calculated%20Column%20with%20department%20from%20a%20People%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1723152%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20beginner%20in%20SharePoint%20online.%20I%20created%20a%20document%20library%20and%20created%20a%20people%20field%20called%20%3CSTRONG%3ERaised_By%3C%2FSTRONG%3E.%20Now%20i%20need%20to%20create%20a%20calculated%20column%20to%20extract%20the%20department%20from%20%3CSTRONG%3ERaised_By%3C%2FSTRONG%3E%26nbsp%3B%20so%20it%20is%20placed%20in%20the%20calculated%20field.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20am%20creating%20the%20calculated%20column%20in%20the%20list%20of%20fields%20there%20isn't%20%3CSTRONG%3ERaised_By%3C%2FSTRONG%3E%20so%20I%20cannot%20create%20a%20formula%20based%20on%20this%20people%20field.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1723152%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Established Member

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