Is it possible for the column to be set as 'single line of text' and in the calculated value portion somehow grab the value from column 1 and column 2?
So the list looks like this:
"col1 text here", "col2 text", "col1 text here col2 text"
mosssharepoint
Is it possible for the column to be set as 'single line of text' and in the calculated value portion somehow grab the value from column 1 and column 2?
So the list looks like this:
"col1 text here", "col2 text", "col1 text here col2 text"
Best Answer
If you just want to concatenate the text of the two columns, the formula
should do what you want. For a bit more complex example, if the column names have spaces in them and you want a space as a separator, use
Or you can use the elaborate concatenate operator
If this is not what you want at all, please rephrase the question. :-)