I am trying to create a list where people in my company can go to share tips and tricks to hopefully make other peoples jobs a little bit easier. I have created a custom list with columns as follows: Date, Submitted By, Department, Category, and Description. My first problem is with the “Date” column. For some reason when it was set up, its type of information was set up to be a “Single line of text.” I would actually like that column to default to whatever date they are entering it on. I know there is an option for “Date” in the type of information. However, for some reason, SharePoint will not let me change that. It will also not let me delete the column, so creating a new column and setting its type of information to “Date” would only confuse the user who is trying to enter something. Any suggestions? Also, I already have the “Submitted By” column set to “Person or Group” for the type of information. It would be easier on the user if it defaulted to their name and they didn’t have to go searching for themselves. Is there a way to have the users name default into that field? Also, I am looking to add a column that will issue every entry a number starting at 1 and going up. I have struggled to find the code to make the column calculate that value.

Hi gjb2008123, You can delete or modify any columns that you add in a list. After you create a column, you can go back and change its settings. For example, you might want to specify that a column contains currency instead of just a number. To view or change the list settings, open the list, and then click List Settings on the Settings menu. For more information about adding a column to a list, please refer to the following article: http://office.microsoft.com/en-us/windows-sharepoint-services-help/create-a-list-HA010099248.aspx For the second requirement, I am afraid that we can’t achieve that without development. For the third requirement, you can refer to the following article: Auto-Increment a Number in a New List Item http://splittingshares.wordpress.com/2008/04/11/auto-increment-a-number-in-a-new-list-item/ Regards, Rock Wang Microsoft Online Community Support

I think it is likely that the "Date" field was originally called "Title" which has some internal functions and cannot be removed. If that is the case, rename it to something else and when you create a new "Date" field, set it to the Date field type and you should be all set.SharePoint Server MVP | Architect | Developer | Administrator | Speaker-- Twitter -- Blog - http://nextconnect.blogspot.com

I then would not be able to delete the column "Title" and I have no use for the cloumn. I could hide the cloumn from view but it would still appear in the form when someone enters something.

Hello, For your 'Submitted By' column, SharePoint automatically creates the 'Created By' column. This column will automatically collect the user information for the person that creates the new item. You should just use this, rather than create a new column that requires users to enter their own user information. For the 'Title' field issue, you can hide this field from the NewItem.aspx form by going into the content type settings and changing the field to "Hidden." Be advised, it is not recommended to change the defaul/out-of-the-box content types, so I would recommend creating a child content type from the content type you are using, then hide the 'title' field.Chris Caravajal MCTS SharePoint Help

That worked perfectly for having the column default with the user’s information. We wanted to be able to see from the list view who had submitted it so we could filter on that column. I got rid of the “Submitted By” column all together and moved the “Created by” column to appear on the view. I knew “Created By” and “Mortified By” were down there, but never thought that they could be displayed when looking at the list view. For the “title” issue, I am confused by what you mean when you say “you can hide this field from the NewItem.aspx form by going into the content type settings and changing the field to "Hidden." Are you saying there is a way to get into the settings of when someone goes to enter something into my list? Can anyone think of another way to add a column that will issue every entry a number starting at 1 and going up besides using the suggestion listed above. I dont have the knowledge of how to do it in SharePoint Designer.