I have a table containing cities, one per line (e.g. 'Chennai'). This table has a column refering the country that the city belongs to (e.g. 'India'). I would like to create a formula field that displays 'Chennai, India', to be used in dropdown list. The reason I want to display the country along the city is because it exists two cities having same name but in different countries.

Unfortunately, referring the 'country' column in the formula field will not give 'India' but the ID of 'India' record, while I would like the name. Reading in the forum, seems there is no workaround. 

Could you please work on a feature that would allow to fetch a record within formula fields and select which column to display?

That would be highly appreciated.

Thanks, 

Adrien