Create formula columns in Gantt

Gantt
#1

Hi support,

I want to create formula column in Gantt. lets say in our Gantt there are three columns column1,column2 and column 3. we configured column 3 =column 1 + column 2.(this formula is user configured one)

So once we change column 1 or column 2 ,the column 3 value should change according to the formula given. Is This possible with DHTMLX Gantt,

Thanks.
Rasagb.

#2

Hello Rasagb,
By default, Gantt uses the name parameter from the column configuration to show the value of the task object with the same name. If you want to change something else, you need to use the template function that allows returning any text or HTML elements:
https://docs.dhtmlx.com/gantt/desktop__specifying_columns.html#datamappingandtemplates
If both columns don’t use the template function, you can return the task properties:
http://snippet.dhtmlx.com/5/53579d1a8
Otherwise, you will need to obtain the result of the template functions and calculate the new value:
http://snippet.dhtmlx.com/5/43ddc976f

If you need something different, please, describe your question in more detail. You can also send a picture of how you imagine it should work.

1 Like