Lookup column limitations

I’ve searched for this before, and today I again noticed the Yes/No column type can not be used for lookup column. Worth listing the supported column types here for future reference.

Not a huge list, I know. The only column types available for lookups are:

  • Single line of text
  • Number
  • Date and Time
  • Calculated Single line of text

But with calculated columns (single line of text), we can make the content from the following column types available for lookups:

  • Yes / No
  • Choice (Drop-down or Radio Buttons, but not checkbox)
  • External Data (and external data additional columns)
  • Currency (but without the currency ($) symbol)

Here is the great post I get the lists from: SharePoint: Not all column types can be used in Calculated or Lookup columns (plus a trick to add back four of them!)


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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s