SharePoint Columns – Pros/Cons of what can be done with such and such data type
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 |
| Multiple lines of text |  No |
No |
No |
No |
| Choice | Yes |
Yes |
Yes |
No |
| Number | Yes |
Yes |
Yes |
Yes |
| Currency | Yes |
Yes |
Yes |
No |
| Date and Time | Yes |
Yes |
Yes |
Yes |
| Lookup | Yes |
Yes |
No |
Yes
(Use only to count number of items) |
| Lookup (projected field) | Yes |
N/A | No |
No |
| Yes/No | Yes |
Yes |
 Yes |
No |
| Person or Group | Yes |
Yes
(No people picker) |
No |
No |
| Hyperlink or Picture | Yes |
Yes |
No |
No |
| Calculated | Yes |
N/A | No |
Yes |
| External Data | Yes |
No |
Yes |
No |
| External Data (projected field) | Yes |
N/A | Yes |
Yes |
| Managed Metadata | Yes |
No |
No |
No |
| (Special) ID | Yes |
N/A | No |
No |
| (Special) Created By | Yes |
N/A | No |
No |
| (Special) Created On | Yes |
N/A | Yes |
Yes |
| (Special) Modified By | Yes |
N/A | No |
No |
| (Special) Modified On | Yes |
N/A | Yes |
Yes |
| (Special) Version | Yes |
N/A | No |
Yes
|
http://domino2sharepoint.blogspot.com![]()
