how I Create a calculated column in SharePoint and writing formula using lookup columns, other.

I want to create a calculated column that the field in the formula I use lookup column

plz, help me!

  • how i can use workflow nintex
    – farbod te
    Commented Feb 13, 2017 at 12:26

1 Answer 1


Unfortunately, Lookup columns cannot be referenced in a calculated column formula.

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

The suggested workaround

  • To use a workflow/event receiver that copies the lookup column value into an another column with a text data type.
  • Then use that copied field in your formula.

Check the detail steps at How to use Lookup field in SharePoint Calculated Column Formula.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.