It would be incredibly helpful to support column formulas that can conditionally calculate values in some cells while allowing manual input in others, based on specified criteria.
Essentially, I'm envisioning a hybrid column formula that can evaluate conditions at the row level and determine whether to calculate a value or accept manual input (e.g., USERINPUT()). This would eliminate the need for separate helper columns to store manual and calculated values.
I build tracking sheets for various projects and then hand them off to project owners for ongoing maintenance. Keeping everything in one column would make these solutions cleaner, easier to maintain, and much simpler to hand off.
