Role of "Title" Column in SharePoint Lists - Can't change column type?

%3CLINGO-SUB%20id%3D%22lingo-sub-2108392%22%20slang%3D%22en-US%22%3ERole%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108392%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20start%20a%20new%20list%20in%20Sharepoint%2C%20I%20always%20get%20a%20%22Title%22%20column%20and%20I%20can't%20change%20the%20type%20from%20the%20default%20%22Text%22%20type.%20What%20is%20the%20role%20of%20the%20%22Title%22%20column%3F%20I'd%20like%20my%20first%20column%20to%20be%20a%20date%20column%20but%20can't%20seem%20to%20figure%20out%20how%20to%20make%20that%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2108392%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2108973%22%20slang%3D%22en-US%22%3ERe%3A%20Role%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676026%22%20target%3D%22_blank%22%3E%40slohombre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20default%20column%20in%20SharePoint%20lists%20which%20comes%20with%20the%26nbsp%3B%3CSTRONG%3EItem%3C%2FSTRONG%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Fdeveloper%2Fsharepoint-2010%2Fms452896(v%3Doffice.14)%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Econtent%20type%3C%2FA%3E.%20You%20cannot%20change%20it's%20data%20type.%20As%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%26nbsp%3Bsaid%2C%20if%20you%20need%20any%20other%20text%20column%20in%20your%20list%20then%20you%20can%20rename%20Title%20column%20and%20use%20it%20for%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20change%20the%20order%20of%20columns%20in%20list%20view%20and%20list%20form%20to%20show%20the%20date%20column%20as%20first%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20if%20you%20don't%20want%20this%20field%20in%20your%20list%20then%20you%20can%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Flist-form-conditional-show-hide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehide%20it%20from%20list%20form%3C%2FA%3E%20as%20well%20as%20from%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fedit-a-view-of-a-list-15916903-e79a-423f-b4e2-02d37e1ff372%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Elist%20view%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2108833%22%20slang%3D%22en-US%22%3ERe%3A%20Role%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108833%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676026%22%20target%3D%22_blank%22%3E%40slohombre%3C%2FA%3E%26nbsp%3Byou%20can%20ignore%20it%2C%20rename%20it%20to%20something%20else%20where%20you%20want%20a%20single%20of%20text%20column%2C%20just%20not%20change%20the%20type%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3Bsaid.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2108464%22%20slang%3D%22en-US%22%3ERe%3A%20Role%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%20Thank%20you.%20So%20how%20do%20most%20people%20deal%20with%20it%3F%20Ignore%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2108460%22%20slang%3D%22en-US%22%3ERe%3A%20Role%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108460%22%20slang%3D%22en-US%22%3EIt's%20a%20system%20column%20and%20the%20type%20cannot%20be%20changed%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281757%22%20slang%3D%22en-US%22%3ERe%3A%20Role%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281757%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373269%22%20target%3D%22_blank%22%3E%40ganeshsanap%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20if%20it%20is%20possible%2C%20somehow%2C%20to%20enforce%20unique%20values%20in%20this%20default%20column%3F%20I%20have%20been%20using%20it%20to%20assign%20unique%20ticket%20numbers%20for%20each%20issue%20that%20comes%20my%20way.%20Since%20I%20have%20many%2C%20many%20items%20in%20this%20list%2C%20it%20is%20tedious%20and%20prone%20to%20human%20error%20to%20make%20sure%20I%20don't%20assign%20the%20item%20an%20already%20used%20number.%20I%20can't%20see%20how%20to%20do%20this%20since%20there%20is%20no%20Edit%20option%20for%20the%20default%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282248%22%20slang%3D%22en-US%22%3ERe%3A%20Role%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034120%22%20target%3D%22_blank%22%3E%40lriscald%3C%2FA%3E%26nbsp%3Bgo%20to%20List%20Settings%20and%20you%20can%20enforce%20unique%20values%20for%20any%20column%20there%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ListSettings.png%22%20style%3D%22width%3A%20716px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274913i96793E6C443A3068%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ListSettings.png%22%20alt%3D%22ListSettings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20there's%20another%20approach%20you%20might%20want%20to%20consider.%20In%20our%20IT%20Ticket%20system%20we%20use%20the%20ID%20column.%20The%20ID%20number%20is%20set%20by%20SharePoint%20so%20you%20don't%20have%20to%20do%20it%20manually%2C%20it%20can't%20be%20changed%26nbsp%3B%20and%20is%20always%20unique.%20And%20that%20is%20the%20number%20that%20is%20used%20as%20the%20ticket%20number%20throughout%20the%20system%2C%20for%20example%20when%20the%20user%20initially%20submits%20the%20ticket%20the%20list%20item%20is%20created%20and%20an%20email%20is%20sent%20back%20to%20the%20user%20by%20a%20flow%20in%20Power%20Automate%20with%20the%20details%20of%20what%20they%20submitted%20and%20their%20unique%20ticket%20number.%20And%20it's%20used%20in%20all%20other%20communications%20about%20the%20ticket%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ListSettings2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274914iCBB3FE6A40D2B018%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ListSettings2.png%22%20alt%3D%22ListSettings2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282659%22%20slang%3D%22en-US%22%3ERe%3A%20Role%20of%20%22Title%22%20Column%20in%20SharePoint%20Lists%20-%20Can't%20change%20column%20type%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282659%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20was%20first%20creating%20this%20list%2C%20I%20did%20explore%20the%20ID%20column%20and%20thought%20it%20might%20be%20useful%20that%20way%2C%20but%20one%20thing%20threw%20me%20off.%20At%20that%20time%2C%20I%20think%20I%20had%20about%20three%20items%20on%20the%20list%20and%20the%20IDs%20that%20came%20up%20were%20something%20like%203%2C%2031%2C%2032.%20In%20other%20words%2C%20they%20didn't%20seem%20to%20be%20numbered%20consecutively.%20It%20is%20possible%2C%20in%20creating%20my%20list%2C%20that%20I%20had%20created%20and%20deleted%20some%20items%20as%20I%20was%20experimenting%20and%20I%20imagine%20that%20once%20an%20ID%20is%20used%2C%20it%20never%20gets%20reused%2C%20but%20I%20certainly%20hadn't%20created%20and%20deleted%2030-some%20items.%20Do%20you%20have%20any%20idea%20how%20these%20IDs%20are%20generated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDespite%20the%20numbering%20strangeness%2C%20your%20suggestion%20is%20a%20great%20one%20and%20that%20may%20be%20what%20I%20will%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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.

10 Replies
It's a system column and the type cannot be changed

@Juan Carlos González Martín  Thank you. So how do most people deal with it? Ignore it?

@slohombre you can ignore it, rename it to something else where you want a single of text column, just not change the type as @Juan Carlos González Martín said.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@slohombre 

 

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.

 

Also, if you don't want this field in your list then you can hide it from list form as well as from list view.

 


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.

 

Hello @ganeshsanap,

 

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.

 

Thank you!

@lriscald go to List Settings and you can enforce unique values for any column there:

ListSettings.png

 

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.

 

ListSettings2.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

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.

 

Thank you!

@lriscald IDs are always created sequentially and are never re-used, even when items are deleted. 

 

Rob
Los Gallardos

One thing to keep in mind about the title column: If you delete a list item - this is the only information you see in the Recycle Bin. So it can be important to put information here that helps identify the item if you need to recover something you have deleted.

I often customise my list with a power app form and I have the Title field automatically populated with info concatenated from other fields.