Concatenate formula for text and dropdown columns

Platform discussions Special workflows & use cases
,
1

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?

2

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

CONCATENATE(
    {Origin#Labels},
    {Document Type#Labels},
    {Discipline#Labels},
    "-",
    {System ID},
    "-",
    {Rev#Labels},
    " ",
    {Name}
)
1 Like
3

Thanks Francis! That worked.

Appreciate the help sir.

1 Like