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?
Answers
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!