Trying to create a formulated/formatted sheet from the inputs of online Form

Aydin Birik

Hello. I am stuck here.

I created a form. In the sheet file, I have some formatting and formulas to run reports based on the inputs coming from the online form.

However, when a new input comes into the sheet as a new row, my formats and formulas that I set up in upper rows do not apply to this newly created one!. I have to manually go into the sheet file and apply formats and formulas from the upper row to this newly created row all the time.

I tried creating a bunch of empty rows with the formulas and formats already set in place, and expect new inputs will be placed into those cells, but in this case, those empty rows get treated as new data inputs and get cell data of "created date" and "created by", gives #Invaliddata type error where formulas and formatting is applied, messes my overall sheet data,- and even worse the new inputs coming from the form position right under to the end of those empty rows - which I end up with where I started at.

So frustrating.

Can you pls help me?

Mark Cronk

Hi Aydin,

Delete all of the rows below your last row of data. Save your sheet. Apply the desired formats to your columns. When new rows are added to the bottom they should adopt the format of the rows above and column.

I've found that formatting is a little more consistent if you can add new rows to the top of your sheet. Is that an option for you?

Work?

Mark