Jan 29 2021 10:07 AM
Jan 29 2021 10:07 AM
When I start a new list in Sharepoint, I always get a "Title" column and I can't change the type from the default "Text" type. What is the role of the "Title" column? I'd like my first column to be a date column but can't seem to figure out how to make that happen.
Thanks for any help.
Jan 29 2021 11:08 AM
Jan 29 2021 11:09 AM
@Juan Carlos González Martín Thank you. So how do most people deal with it? Ignore it?
Jan 30 2021 02:25 AM
Jan 30 2021 09:16 AM - edited Jan 30 2021 09:22 AM
This is a default column in SharePoint lists which comes with the Item content type. You cannot change it's data type. As @RobElliott said, if you need any other text column in your list then you can rename Title column and use it for that.
You can change the order of columns in list view and list form to show the date column as first column.
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Apr 22 2021 10:46 AM
Do you know if it is possible, somehow, to enforce unique values in this default column? I have been using it to assign unique ticket numbers for each issue that comes my way. Since I have many, many items in this list, it is tedious and prone to human error to make sure I don't assign the item an already used number. I can't see how to do this since there is no Edit option for the default column.
Apr 23 2021 12:17 AM
@lriscald go to List Settings and you can enforce unique values for any column there:
But there's another approach you might want to consider. In our IT Ticket system we use the ID column. The ID number is set by SharePoint so you don't have to do it manually, it can't be changed and is always unique. And that is the number that is used as the ticket number throughout the system, for example when the user initially submits the ticket the list item is created and an email is sent back to the user by a flow in Power Automate with the details of what they submitted and their unique ticket number. And it's used in all other communications about the ticket as well.
Microsoft Power Automate Community Super User
Apr 23 2021 07:58 AM
Thank you so much, @RobElliott.
When I was first creating this list, I did explore the ID column and thought it might be useful that way, but one thing threw me off. At that time, I think I had about three items on the list and the IDs that came up were something like 3, 31, 32. In other words, they didn't seem to be numbered consecutively. It is possible, in creating my list, that I had created and deleted some items as I was experimenting and I imagine that once an ID is used, it never gets reused, but I certainly hadn't created and deleted 30-some items. Do you have any idea how these IDs are generated?
Despite the numbering strangeness, your suggestion is a great one and that may be what I will do.
Apr 23 2021 08:17 AM
@lriscald IDs are always created sequentially and are never re-used, even when items are deleted.
Sep 02 2021 09:11 PM