Hi there,
Just wondering if anyone could help me with a problem I’m having.
I’m trying to make an estimating sheet which calculates material totals and installation times. It all works fine when the formulas are included in the original data source but when I add another row using the button the formulas do not work. Any ideas why this might be?
http://jsfiddle.net/g529nzka/5/
thanks
Hey @waltersluke87
the formulas are in an alpha stage of development. In some cases they do not recalculate.
What you’d like to get after a new row is added?
Hi thanks for the reply,
I would just like for the calculations in the new rows to work. For example when I click ‘Add’ and a new row is created, the ‘net’ column to calculate the sum.
In the case of the 3rd row it would be. "=SUM((E3/100)*F3) "
If this is not possible as the formals as still in alpha stage, is there a work around using javascript?
Thanks
It should be possible. I will investigate it and share my thoughts after the weekend.
That works a treat. thanks and much appreciated.
I’m glad to hear that. Have a great weekend.