Automation Rules

ORIGINAL SETTING NEW SETTING OUTPUT
Mitigation Status = proposed In Progress Mark the actual start date with today’s date.
Mitigation Status = proposed Complete Mark the actual start date with today’s date and the actual finish date with today’s date.
Mitigation Status = In Progress Proposed Remove the actual start date.
Mitigation Status = In Progress Rejected Remove the actual start date.
Mitigation Status = In Progress Complete Mark the actual finish date with today’s date.
Mitigation Status = In Progress Approved Remove the actual start date.
Mitigation Status = Rejected In Progress Mark the actual start date with today’s date.
Mitigation Status = Rejected Complete Mark the actual start date with today’s date and the actual finish date with today’s date.
Mitigation Status = Complete Proposed Remove the actual start and finish dates.
Mitigation Status = Complete In Progress Remove the actual finish date.
Mitigation Status = Complete Approved Remove the actual start and finish dates.
Mitigation Status = Complete Rejected Remove the actual start and finish dates.
Mitigation Status = Approved In Progress Mark the actual start date with today’s date.
Mitigation Status = Approved Complete Mark the actual start date with today’s date and the actual finish date with today’s date.
Mitigation Status = Risk Closed Proposed Remove the actual start and finish dates.
Mitigation Status = Risk Closed In Progress Mark the actual start date with today’s date unless it is already marked and remove the actual finish date if there is one.
Mitigation Status = Risk Closed Rejected Remove the actual start and finish dates if they exist.
Mitigation Status = Risk Closed Approved Remove the actual start and finish dates if they exist.
Risk Status = Open (Any) or Impacting Closed (Any) Set all mitigation status to “Risk Closed.”  Do not change the actual dates.
User sets an actual start on mitigation Set mitigation status to In Progress unless it is already in In Progress or Complete status.
User sets an actual finish on a mitigation Set mitigation status to Complete if not already in Complete status.
Create new risk Set risk ID based on a timestamp Set the risk ID based on a timestamp if the user did not type in the ID column to create the risk.  ID = T + timestamp for threats.  O + timestamp for opportunities.  User can overwrite.
Create new mitigation step Set mitigation ID based on a timestamp Set the risk ID based on a timestamp if the user did not type in the ID column to create the mitigation.  ID = M + timestamp.  User can overwrite.