I am trying to use a list field in a formula field, and instead of the text from the list, I get a large number
I have 3 forms. In form 1, I enter a list of hospitals to be use in a Schedule form as a dropdown. In form 2 I enter a list of nurses to be used in a Schedule form as the person being scheduled. In the Schedule Form, I have a drop down, Facility, that is linked to the hospital list form; I also have a field Nurse Name that is linkd to the nurse list form. I then create a formula combining the text of Facility +" "+Nurse Name. Instead of the text I selected from the dropdowns, I get large intergers.
For example, I may select Smith Hospital and Jenny Jones from the two dropdown list fields. What I want in the formula results is "Smith Hospital Jenny Jones"
I am assuming that the large numbers I get instead are the lookup list index value. How do I get the text I selected in a list lookup field and use it in a formula?