Re: Calculated Field using a Lookup Column



When I try this, I get the following error:
One or more column references are not allowed, because the columns are
defined as a data type that is not supported in formulas

"TheGoodOmen" <TheGoodOmen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9AD6F815-3C08-45BE-B6A4-BBD291141241@xxxxxxxxxxxxxxxx
Dean,

Here is what I am using to concatenate two fields (RC # and RC Title).

=CONCATENATE([RC #]," - ",[RC Title])

The example output looks like "54880 - Engineering".

Hope this helps.

"Dean" wrote:

How can I concatenate data from a Lookup column with data from another
text
column in a new Calculated column?

TIA
Dean





.