In a formula column, the EXTRACT_ELEMENT () function allows you to extract an element contained in a cell according to various parameters:

- You can extract the 1st element

- You can extract the last element

- You can choose what will be the element separator

For example, you want to know what was the last action taken for your client from a list of actions

Formula

For 1st element

EXTRACT_ELEMENT (Column with multiple elements, 1 ,;)

The first parameter is the column containing your multiple elements.

The "1" conditions the search for the 1st element.

The ";" here is our separator. TimeTonic uses the default separator ",". The formula therefore works by default with this type of separator. No need to notify him.

For last element

EXTRACT_ELEMENT (Column with multiple elements, -1)

The first parameter is the column containing your multiple elements.

The "-1" conditions the search for the last element.

The ";" here is our separator. TimeTonic uses the default separator ",". The formula therefore works by default with this type of separator. No need to notify him.

Example

For 1st element

EXTRACT_ELEMENT (Commercial actions column, -1)

I want to know what stage we are in by extracting the last item from a list of stages.

And here is the rendering, the column "Sales stage" returns you to the last step:

For last element with separator 

EXTRACT_ELEMENT (Commercial actions column, 1 ,;)

I want to know what stage we are in by extracting the first item from an action list.

And here is the rendering, the "First action" column sends you back to the first action taken: