The concatenation function is used widely to form a combined text string from several independent text variables which can include anything, with the most widely used variables being attributes and properties such as name and categories. It is extremely useful in forming a WBS structure on the timeline view, to be able to show a roll-up functionality within the timeline.







x = any variable you wish to be combined into a single string


Type of Data Returned


Will return a string




CONCAT([“SharpCloud ”, ‘ ‘, “Software”, ‘ ‘, “Ltd”]) will return SharpCloud Software Ltd


Using the CONCAT function to form a WBS structure, where the items are Projects and they have an attribute called Programme, showing what Programme the projects belong to:


CONCAT([Programme, “.”, name]) will return Programme 1.Project 1 for example, which could then be displayed on the Y-Axis.