MarkoPavlovic
8 months agoQrew Member
Concatenating two fields (Lookup field + Text Field into third filed)
Hi Everybody,
Can anybody help me i would like to cut a corner and concatenate two fields into one.
One field is a drop down/lookup field and the other one is text.
In another words i would like to put together Project Name and City field as the customer is calling its sites like that.
Can anybody advise how i can do it i tried
If([Project Name]="[Project]",([Project Name]),([City]))
If([Project Name]="",[Project Name],[City]
but it returns only city name
I know i can export and then concatenate and then import but i would like to shorten the way if possible
------------------------------
Marko Pavlovic
------------------------------