Is it possible to over ride a formula when using Column Formulas

Murph

I have a sheet where new rows are automatically added to the bottom of the sheet from a form. I want the newly added rows to have formulas added to them, which I can accomplish using the Column Formula feature. However, I want to be able to over ride the formula in some cells.

Specifically, a new row is added from the form that contains a due date and I can use Column Formulas to calculate milestone dates to meet that due date, but sometimes priorities shift and I need to adjust a milestone date. When I click on the milestone cell and try to manually enter a new date, the sheet will not recognize the manual entry.

Is there any way to work around this?

Ryan Sides

Hi Murph, if your new rows are always coming from forms, you can remove the column formula. As long as the formula exists on the last row, it will auto copy to the next row (unless I’m thinking about the copy row function, which I can’t test bc I’m on mobile).

then you can override it.