I have an Assignment form that has a lookup field for the title of all existing projects. It also has a field for the person I want to assign a task to. I have a formula field that is supposed to give me the name of the project and the person assigned to it (So I can use that in a To-Do form later on).

Every time I select a project in the Assignment form it returns a long number in the formula instead of the name of the project.

I have compared what I have done to what was done in the Project Organizer app (in the marketplace) and it appears identical to me, yet mine returns a number and theirs returns the name.

what am I doing wrong?