Using Lookup Field in SharePoint Calculated Column Formula

In this article, I will explain

How to use Lookup Field in SharePoint Calculated Column Formula

Scenario

I have a list with a lookup field, I would like to use this lookup field in in SharePoint Calculated Column Formula but unfortunately, it’s not listed in the available formula column as shown below:Using Lookup Field in SharePoint Calculated Column Formula

Cause

It’s by design, The lookup column can’t be used in SharePoint Calculated Column Formula and SharePoint Column Validation.

Check The Supported and Unsupported Columns in SharePoint Calculated Column Formula.

Workarounds

Continue reading Using Lookup Field in SharePoint Calculated Column Formula

Advertisements

Using ID Field in Calculated Column in SharePoint

In this article, I will explain

How to use The ID field in Calculated Column in SharePoint?

Scenario

I have tried to add ID field in a calculated column that added successfully without any error in the formula.

But I noticed that the calculated column is not calculated on the item added or updated!

Cause

Continue reading Using ID Field in Calculated Column in SharePoint

Popular SharePoint / Office 365 Courses in Microsoft Virtual Academy

In this post, I am trying to list

The most popular SharePoint / Office 365 Courses in Microsoft Virtual Academy

Last updated: 10/2017


Microsoft Virtual Academy SharePoint On-Premise Courses (16)

Microsoft Virtual Academy SharePoint Courses List

General (5)

  1. SharePoint at Microsoft
  2. How Microsoft IT Manages and Governs the Internal SharePoint Environment.
  3. SharePoint 2013 Best Practices
  4. Managing SharePoint On-Premises vs. SharePoint Online
  5. Mastering Microsoft Certification Exam Prep.

Administration (8)

  1. Initial Implementation of SharePoint Server
  2. Provision and Configure Web Applications in SharePoint 2013
  3. Create and Maintain Site Collections in SharePoint 2013
  4. Plan and Configure User Access for SharePoint 2013
  5. Create and Configure the User Profile Service (UPS) Application
  6. Create and Configure the Managed Metadata Service (MMS) Application
  7. Upgrading to SharePoint 2013
  8. Deploying & Managing SharePoint 2013 with PowerShell

Development (3)

  1. Developing Microsoft SharePoint Server 2013 Core Solutions Jump Start
  2. Developing SharePoint Server Advanced Solutions Jump Start
  3. Deep Dive: Building Blocks and Services of SharePoint.

Microsoft Virtual Academy Office 365 Courses (78)

Microsoft Virtual Academy Office 365 Courses List

Continue reading Popular SharePoint / Office 365 Courses in Microsoft Virtual Academy