How to combine two items by formula edit?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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!
Re: How to combine two items by formula edit?Thanks a lot for my question! It's very clear.
Re: How to combine two items by formula edit?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
