Forum Discussion
Calculated Colum's in SharePoint 365
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];"-";[Titl...
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.