I have an issue tracking list inside my SharePoint 2013 enterprise server. The issue tracking have these columns:-
- Item status. In progress, Cancelled, Published
- Publish Date
- Duration in months
- End date.
Now currently I want to force this rule inside my list. when a user change an item status to be “Published” to have these values automatically calculated:-
- Publish Date = Today date.
- End Date =Publish Date + Duration in months.
- Users can manually change the publish date & duration in months. While End Date should not be editable.
So can anyone advice on this please?