
I would like to have the same Type field on every Contact associated with that Account, and have that same Type field populated with the same answer that exists for Type on the Account. So if the Account is Exxon, and the Type is Enterprise, I want Type to be Enterprise for every Contact associated with Exxon.
I have spent a couple of hours playing with Lookup fields and have not been able to get this to work. Any suggestions would be most appreciated.
8 réponses
You need to use a TEXT function to convert it, like this:
TEXT(Account.Type)