Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated Columns in Lists

  Asked By: Gonzalo    Date: Sep 12    Category: Sharepoint    Views: 10504

Are there any ways to use lookup columns in a list that reference to other lists in a calculated columns?

I can do all sort of calculations on all entered data (text, numbers, etc that exist within the list) but cannot find a way to do the same with the values taken from lookup columns referencing other lists or AD.



1 Answer Found

Answer #1    Answered By: Alphonso Mckay     Answered On: Sep 12

That is because the lookup  column stores the ID of the associated
listitem not the selected value. That is why you can change the selected
listitem and the change will reflect thru the lookup dropdown for
previously selected values.

Didn't find what you were looking for? Find more on Calculated Columns in Lists Or get search suggestion and latest updates.