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

How can I set the default value of a calculated column as a user / group name. Basically I want to create a view with that column included and where column name = [Me] so that if I/logged-in user is a part of group, I can see object in library.

share|improve this question
up vote 0 down vote accepted

Calculated columns don't have default values because they are derived from values existing in another field. Person/group fields cannot have a default value so you'd have to have some script to populate it when the form is filled out.

I'd probably just create a view in the list with a filter where Created by equals [Me] and add additioanl filters that restrict data based on other columns to achive a similar result.Creating a view filter

share|improve this answer
But I want to fill the value of the custom column with a specific user/group. How do I do it? Only then I will create a view to filter contents. – Ashish Sep 6 '11 at 12:32
Updated the answer, hopefully it helps. – Eric Alexander Sep 6 '11 at 13:52
Apart from Calculated Columns, is there any other type of column we can use..? Like the Person/Group column..? – Ashish Sep 6 '11 at 15:15
Yes, you can use a person/Group column, but you need script to set the field value, it doesn't accomodate a default value. – Eric Alexander Sep 6 '11 at 15:24

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.