Concatenate formula for text and dropdown columns

Hi everyone,

I’ve looked everywhere for a way to solve for an “illegal formula” result while attempting to use the Concatenate function to combine a series of text and drop down columns.

CONCATENATE({Origin#Labels}{Document Type#Labels}{Discipline#Labels},“-”,{System ID},“-”,{Rev#Labels}," ",{Name})

This is the formula I have now and previously I didn’t have the " , " before and after the - marks but this still isn’t working.

Anyone have an idea of why I’m getting this illegal formula result?

My first guess would be no commas between the first three variables. Could you try this?

    {Document Type#Labels},
    {System ID},
    " ",
1 Like

Thanks Francis! That worked.

Appreciate the help sir.

1 Like