AnsweredAssumed Answered

Calculated Lookup field returning #Value!

Question asked by jngo on Dec 9, 2015
Latest reply on Dec 11, 2015 by kojeeman

I am using a list with 4 lookup calculated fields, 3 of them return the correct data while 1 shows "#Value1". The difference with that one is it is looking up a lookup column selected.


Here is a picture:



Once I select "Jon Ngo" in Original Internal Notification, the calculated fields populate Employee Name, Current Office Number, and Current Title (all three being single-line of text). The Current Department is not showing the name of the department, but instead  #Value! (this is pulling from a lookup column from another list called 'Department')


Am I doing something wrong?