SharePoint Columns – Pros/Cons of what can be done with such and such data type

Standard
Thank to Toni Frankola, SharePoint MVP, for this mash-up of what every client asks at one point …

SharePoint Columns – Features and limitations | SharePoint Use Cases

Column Type Ad-hoc filter & sort Edit in Datasheet view Use in calculated columns Use for Lookup columns
Single line of text yes Yes yes Yes yes Yes yes Yes
Multiple lines of text No No No No
Choice yes Yes yes Yes yes Yes No
Number yes Yes yes Yes yes Yes yes Yes
Currency yes Yes yes Yes yes Yes No
Date and Time yes Yes yes Yes yes Yes yes Yes
Lookup yes Yes yes Yes No yes Yes

(Use only to count number of items)

Lookup (projected field) yes Yes N/A No No
Yes/No yes Yes yes Yes yes Yes No
Person or Group yes Yes yes Yes

(No people picker)

No No
Hyperlink or Picture yes Yes yes Yes No No
Calculated yes Yes N/A No yes Yes
External Data yes Yes No yes Yes No
External Data (projected field) yes Yes N/A yes Yes yes Yes
Managed Metadata yes Yes No No No
(Special) ID yes Yes N/A No No
(Special) Created By yes Yes N/A No No
(Special) Created On yes Yes N/A yes Yes yes Yes
(Special) Modified By yes Yes N/A No No
(Special) Modified On yes Yes N/A yes Yes yes Yes
(Special) Version yes Yes N/A No yes Yes

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s