text value in formula who use lookup

text value in formula who use lookup

Hi,

i would like to see the text value result ( and not the ID ) when i use lookup result in my formula.

exemple ( client_name is the lookup field)

input.client_name+ " " + input.adresse

result :

10800000000 rue de la paix 75012 paris

regards