Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

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

1 Answer

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. – PirateEric 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. – PirateEric Sep 6 '11 at 15:24

Your Answer

 
discard

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.