We need the ability to apply a default formula to a column (such as =[Request Date]@row + 7), but allow users to override the result on a row-by-row basis when needed.
Currently, if we use a Column Formula, it locks the entire column and users can't make exceptions or input a different value in one row. If we remove the column formula and use row-level formulas instead, we lose the ability to apply it automatically to new rows without complex workarounds.
This restriction creates friction in workflows where:
- A date or value is almost always calculated the same way (e.g. 7 days from a request)
- But occasionally, the logic needs to be overridden for outliers (e.g. larger projects)
We’ve tried:
- Two-column formulas (Manual + Calculated), but this creates extra clutter and confusion
- Automation to populate values, but change cell value cannot be used for a date field, and the field must be a date field in order to send reminder emails based on the alert someone automation
