Concatenate two columns

[Eduardo_Dalcin]

Hi!

I’m trying to concatenate two columns where one is reference of the other. I got this:

Using: "=CONCAT($Taxa, " - “,$rankSup)”

Is there any way to get “xAliceara - Orchidaceae” at the “A” column?

Thanks again!

Eduardo

[alexmojaki]

Think of a reference column as containing the referenced records themselves. One of their columns is displayed for convenience but formulas have access to the full record which allows doing more. So $rankSup is a record, not a string. You need to retrieve the column using $rankSup.Family or something to get the string value of the relevant column in the referenced table.

[Eduardo_Dalcin]

Works beautifully!

Thanks!