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 …

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