Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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 stackoverflow.com Mar 13 '12 at 0:28

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

1 Answer 1

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.