Need to create new column in the documnet library. this column should have default value from the existing columns like Created by.down the road if it need to chage then it should be edit. Any idea how can i pull data from existion column as defual vaue

Yes, easily done by adding a column of type calculated column.

any idea how to get created by column vaues as default to another cloumn in WSS 3.0(NO MOSS SERVER).what is the formula in calc column.help me out

If you are only interested in getting created by in a column of your own, you could do the following (In WSS3). Create a new column of type Single line of text Set the default value to Calculated Value and in the text box type "=Me" Save this and add a new item to the list, you will see your AD Login in this new column.

This looks greate,its getting the windows login. for my requirment i am looking to get the login user name of sharepoint site, created by column vlaue when the new doc is uploaded to the doc library.i want to same column value as the default column value to my new column

glad to help. Let me know if you need anything else, if not then you could mark the answer and close the thread.

for my requirment i am looking to get the login user name of sharepoint site, its same as created by column vlaue when the new doc is uploaded to the doc library. i want to get the same column value(Created By column value)as the default value to the new custom column.

Hi, For your scenario, Out of box it’s impossible for using the existed column value as default value. When you are creating new item, how does custom column know what’s the value of “Create BY” column? You need do some customization or program to achieve this. When you created the new item, you can attach a workflow or event handle to update the custom column based existed column. For creating a new event handle, please refer to http://msdn.microsoft.com/en-us/library/ms437502.aspx http://farhanfaiz.wordpress.com/2007/12/31/creating-adding-an-event-handler/ For creating new workflow in SharePoint Designer, please refer to http://office.microsoft.com/en-us/sharepoint-designer-help/create-a-workflow-HA010100591.aspx Hope this helps Thanks! Stanfford

OK, I wanna make sure does the Out of box has this kind of functionality. Thanks for your help. I will work with event