In this article we will learn to combine the values in multiple columns together with a formula column. With the help of some methods we can enhance their functionality.
CONCAT()
Concatenate links together different fields (especially characters and text) in a chain or series like a string. A simple example would first name and last name - both of which you have put in separate columns in Stackby. You need to bring both together in a separate column. Because it is text, you need to use the CONCAT formula to bring them together.
Formula: CONCAT({First Name} ," " , {Last Name})Result:
We combine several columns with the help of CONCAT() function, in the primary column it is used most commonly. You can learn more about how CONCAT() works in primary column.
Alternative to Concatenate
Concatenate is used to combine values instead of that ampersand (&) can be used as a separating character.
Example:
Result:
Adding Line Breaks
We combine several columns with the help of CONCAT() function, but what about if we want line breaks in between? So for that we will use "\n" as a formula. Basically \n is used to add line breaks for more readable result or output.
For example, you may want to combine the more than 2-3 columns then we will use formula as
Result:
As we can see, the description column is not in readable form, so we can make it more impressive by using the “\n” formula. Basically to add line break.
Result:
You can learn more about how line breaks works.