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?