I have a spreadsheet in which I have locked the columns that contain formulas
so that people who input data to the spreadsheet will not inadvertently type
over the formulas. The problem I am running into is that when someone
inserts a new row, the formulas need to carry into the inserted row, is there
a way to do that?

My other question is:

In my spreadsheet, I have preformatted one column to put "Yes" if the
processing times of 3 identified cells is less than or equal to .75. The
only problem is that it puts "Yes" in the cells that do not have any data
input into them yet. Is there a way to have it display "TBD" until someone
enters data into that row?