0

Trying to create a calculated column in a List in SharePoint2013 Online based on 2 other columns that get values from another Lookup table(having a text column). So now my List looks:

  • Title Planned Original Difference

  • Proj1 2016W52 2016W51 1

  • Proj2 2017W1 2017W4 -3

  • Proj3 2016W52 2017W1 -1

The Difference = PlannedWeek- OriginalWeek. What formula could i apply to the calculated column in such a scenario.

3

SharePoint doesn't allow Lookup column to be part of the Calculated Column formula . so you can't directly do this, instead you can create a List Workflow using SharePoint designer which will run when an item is changed or created and update the lookup column value to another custom column.

and this custom column can be used in the calculated columns formula.

here whenever the value in the lookup list for that column changes it doesn't get updated to the custom column. it needs to be taken care.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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