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?

Tags:

Answers

  • Ryan Sides
    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.

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!