The Supported and Unsupported Columns In SharePoint Calculated Column Formula

In this article, I will list

The Supported and Unsupported Fields in SharePoint Calculated Column Formula

The Supported and Unsupported Columns in SharePoint Calculated Column Formula Continue reading “The Supported and Unsupported Columns In SharePoint Calculated Column Formula”

Advertisements

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”