You need to sign in to do that
Don't have an account?
Natalie Deering
Formula date field that can be overwritten?
I need to create a field that is a formula field that auto-populates the date as two weeks from the Close Date of an opportunity but can be overwritten...can anybody help?
You could accomplish this using a workflow rule that fires when the Close Date of an opportunity changes. The workflow rule could implement a field update on your custom field and set its value to two weeks from the new close date. Users should then be able to override the value later if they wish. If you only want the rule to fire once then you can set the criteria to instead be only upon record creation. Hope that helps!