I have created a spreadsheet for my church that tracks all the contributions that are coming in. I recently created a form for them to input the data into to make it easier, but the data is not going to the correct cells. The reason for this is that the form is looking for the 1st empty Row to input the data into & the Row has formulas that are not seen working in the background. What can I do to get the data to go to the 1st empty cell in a particular column or at least not recognize the formula in the Row until the conditions are met?
Any help on this will be greatly appreciated.