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

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.