nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to combine two items by formula edit?

As title, I want combine "Item" &"Test list"

ex: I wonder the new column as "Cu solution-8540A" by using formula

Please teach me ,many thanks!

Accepted answers

Use the function Concat, which is equivalent to the operator ||. It is found under Character functions in the formula editor.

This formula should give the desired result

:Item||"-"||:Test List

All comments

Use the function Concat, which is equivalent to the operator ||. It is found under Character functions in the formula editor.

This formula should give the desired result

:Item||"-"||:Test List

Thanks a lot for my question! It's very clear.

Quick Links