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

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?

Find more posts tagged with

Forms

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.