Now I’m not sure if I”ll explain this perfectly so if you need more info please ask. Basically what I am trying to do is add to my script some code that inserts a formula into a designated column but changes the row based on the row its in. So the column will always be K and the row will be whatever the first row is such as 3, so the formula in K3 would be =if(J3 = “”, “”, J3/2). And then when i make a new entry it adds to the next row the in K4 =if(J4 = “”, “”, J4/2).

I havent really tried anything as of yet cause I am unsure, though I have tried to research and found nothing