I want to fill a single column of my sheet with a function, the sheet is being managed by forms. So, whenever a new entry is added it adds a new row and that row will not have the function that I want, meaning that I'll have to go into the data and manage it on my own(which is inconvenient, and would work against what I would want this sheet to do). My data looks something like this:
A B C D E F 1: time, data1, =D1/E1, data2, data3, data4 2: time, data1, =D2/E2, data2, data3, data4 3: time, data1, =D3/E3, data2, data3, data4 4: time, data1, =D4/E4, data2, data3, data4
I want to insert my equation into column C, but every time new data is added through the form the equation will not be in the new row that is added.