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

SP 2007, calendar list. Want to add a column that gets its default value from "Created By" but then allows that to be edited. This is what I tried:

  1. Create column
  2. Give it a name
  3. Leave type set to Single line of text
  4. Change Default value to Calculated Value
  5. Enter =[Created By]
  6. Click OK

SP throws this error:

One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.

Is there another way to do what I need?

share|improve this question
    
@Steve: Click the tick next to the best answer to give your thanks. Cheers! –  Alex Angas Feb 11 '10 at 5:16
add comment

5 Answers

Try to insert

=[Me]

Also look at my answer to a similar post here:

Calculated value for Title field?

share|improve this answer
    
That did it! Thanks much. I feel like such a SP newbie. –  Anonymous Feb 10 '10 at 23:14
    
When someone edits the properties the column will then be updated with that current user, which may not be the person who created it. –  user5123 Oct 5 '11 at 16:19
    
@Stein I went ahead and converted your answer to a comment. With a bit more reputation, you will be able to post comments everywhere. –  Kit Menke Oct 6 '11 at 13:49
    
@Stein - this is for the Default Value - not a calculated column, so only applies when the record is first created. –  Ryan Jan 31 '12 at 13:12
add comment

This will do the trick:

=[Me]

“Today”, “Me” and SharePoint

share|improve this answer
    
I wish it would display the person's full name rather than the login, but it's good enough for what I need. –  Anonymous Feb 10 '10 at 23:31
add comment

Me will display the value for the current user only. If the item was not created by "Current User" even then this column will be displaying Current User's name which is incorrect in this scenario. You cannot use "Created By" column as it is not supported by SharePoint calculated field mechanism.

share|improve this answer
1  
well the person that creates the item should be current user, right? "Me" will display as domain\account. The user can then choose to accept his own login that is suggested as default, or type in another value. –  Anders Rask Feb 11 '10 at 20:40
1  
Easy to see why you would think this, Namwar, but calculated columns are calculated on item save, and then stored as text (to prevent excessive load on the server). Therefore, a "Me" column will always contain the name of the user who last edited it. Yes, it's a bug rather than a feature, but it's a convenient one. –  Mike Redden Aug 11 '11 at 12:24
add comment

Using =[Me] generates an error in SP 2010 anyway.

Just change the name of the createdby column to whatever: Requestor - Signee whatever you need that works.

share|improve this answer
    
-1 The OP mentions that the column should be editable. Also, I'm not sure why you think =[Me] in a default value causes an error, perhaps you have an unrelated issue? –  Stuart Pegg Nov 22 '11 at 10:42
add comment

I would create a SharePoint Designer workflow to populate the "editable created by" field with the "created by" field whenever an item is created and skip calculated columns altogether.

share|improve this answer
add comment

Your Answer

 
discard

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