Forum Discussion
ShawnRenn2
8 years agoQrew Trainee
A simple fix would be to modify the end date to be a formula-date field, to include either a duration, or a reference to a duration field.
Example...
if all you had was start and end date field, you could add a Duration field and a new field called End Date Formula.
Lets assume that not all of your tasks are recurring, and some you want to set manually, others should be driven by the start date and a default duration....
You could write the formula with the condition that if the existing End date field is populated, (which could only happen now if a user filled it out) then the formula would use that as it's value, otherwise it would use the start date + duration to generate it's own end date.
Doing it this way allows you to rely on ONE end date field for reporting without having to choose between automatic or manual.
Try this formula...
If([End Date]="",([Start Date]+[Duration]),[End Date]))