How do you get the value of a lookup field instead of the record number
I using the value of a lookup field on a form in another formula on the same form and instead of the value being placed in the formula, the record number is placed there.
The formula ---- input.Competitor + " - " + input.Media_Channel + " - " + input.Offer
Competitor is a look up field on this form from another form/table.
When this formula runs, I get the following result
3444267000000037515 - House File - 20% Off All Men's Wear
I get the record #, not the value in the field. How do i fix this?