Creating a prepopulating date formula that can be changed by others
I am trying to create a formula that will prepopulate a date cell with a date from a previous cell. I have one column with an "Initial Completion Date" (first date expected to complete a project on) and "Expected Completion Date" (defaults to initial completion date unless project expected to be completed later).
Both are manually input, and the problem that I'm facing is that users are forgetting to fill the estimated completion date cell. However, I don't want users (besides admin) to be able to change the formula, but still be able to change the estimated completion date. Not sure if this is possible, but figured this would be the place to ask!
Help Article Resources
Check out the Formula Handbook template!