Calculated Colum's in SharePoint 365

Contributor

Hi Folks

 

fighting with a simple task.... want to get Column A and Column B in Column C

Example Input
US

ServerX

 

Example Output

US - ServerX

 

My Way

=CONCATENATE([Location];"-";[Title])

 

if I want to save it, Error - no valid syntax 

3 Replies

@PaddyB you just need =[Location]&"-"&[Title]

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Hi @RobElliott 

 

thanks so much... already a bit better... if i use

 

=[Location]&"-"&[Title]

 

i still get an error. if I use for example =[Likelihood]&"-"&[Title] it works... what is the difference?

 

the "Location" is a Dropdown the other are normal cells with numbers and / or text... can this be a Problem?

It works fine with a choice column, or a combinatin of choice and other columns, so there must be soemthing else causing that problem.