How auto generate formula when adding column using spliceCol()

Tags: #<Tag:0x00007efc6060ae88>
#1

Greetings,

I have developed a table where it be able to add column at specific point by using spliceCol(), upon adding those row how do I generate the column with similar formula from the left column. Which means if I’m adding one column it should replicated from the left column just that the first cell will have different name.

Here is the fiddle link

#2

Hi @harvindran.chandrase

you can use the getDataAtCol() method and just replace the fields in the array with your new values within the spliceCol()
ps. I’ve added the info in your previous post - the spliceCol() can be used to replace the data but not to add a new column if you use object data/columns.

#3