Link to home
Start Free TrialLog in
Avatar of GlynnGiacone
GlynnGiacone

asked on

Set List Column field to Created By

I need to create a column in a list and have it's content set to the same value in the automaticallty set "Created By"  column
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

created a calculated column that does this.
or, use a workflow to copy the value from one column to the other.
Avatar of GlynnGiacone
GlynnGiacone

ASKER

What would the syntax be in the Calculated column field to get the 'created by' value? i.e. '= [xxxxxxx]'
Try ["Author"]. The Modified By is ["Editor"] I believe.
http://www.sharepointkings.com/2008/06/sharepoint-column-names-internal-name.html 
I get an error when creating a column with the calculated look up of =[Author] or = ["Author"]
I also get an error when creating a column with the default value set to a calculated vlaue of  =[Author] or = ["Author"]
why not use [ME] ?
the person who creates the item is [ME] and is also the Created By person...  

the thing to test / watch out for is when the item is edited, the value in that calculated column may get updated to the Edited By person.

the other way to do this is with Sharepoint Designer, create a workflow that copies the value in the Created By field to the other column.
I tried using [Me] but that gives the logon id in the form of domain\user.

My client is looking for the same user information (last name, first name) from Created By but without the use of a workflow, to be the default in a column, i.e. Employee Name.

Is there a system field similar to [Me] that gives the user name and can be referenced in a calculated column or set as a calculated value in a text column?
ASKER CERTIFIED SOLUTION
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.