SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a custom-built project requirement list in which I need to store Person's name and Department id (both from outlook contacts property).

What I want to do is when user fills in details in Person column, I want to propose department name (of course, user will have the possibility to change this value).

I am not sure if this is possible, but in the column property, one can set default value. The default value can be a Caluculated Value which can be generated thru formula. Can some one help me with a formulat where in from the person's name, I show his department.

Thanks in advance. Madhu

share|improve this question

migrated from Mar 13 '12 at 0:28

This question came from our site for professional and enthusiast programmers.

Sorry, there is no formula to look up information from the users account details. This would require a custom field to make and LDAP or SharePoint profile lookup.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.