I have a Google spreadsheet connected with a Google form. When a new response is submitted, the formula in the upper rows should be copied down to the new added (by Google form) row.
I have used once
onformsubmit trigger for another similar situation. But when it comes to writing the formula, I want to be copied down in script, as I am neither a programmer nor a coder, it is being a real problem again.
Here is the formula I wanted to use:
if($D6<>"aroonbank",if($F6="Income (Kirim)",5010,if($F6="Advance returned (Qaytarilgan avans)",5010,if($F6="Bank (Bankka pul topshirish)",5110,))),if($F6="Income (Kirim)",5110,if($F6="Advance returned (Qaytarilgan avans)",5110)))
Could someone please help transfer this formula to "google script" language?