I have a Request form in which the RequestedBy user loaded at first and i want to show the department and workphone of the current user in form loading. I have given formula field with the below formulas
userProfileLookup(RequestedBy, 'Department') => for Department
userProfileLookup(RequestedBy, 'WorkPhone') =>for phone.
Same formula i have used in my developement server for getting these data. It works perfectly. But in my production server it shows "#value!"
Please find the attachments for calculated field config. both single quotes and double quotes i already tried. eg: 'Department and "Department"'
Please help me.