The ‘status’ of a milestone is calculated depending on the value of the ‘% Complete’ cell:
a) If “% Complete” is 100%, the status is “Accomplished”
b) If “% Complete” is greater than 0 and less than 100%, the status is “In Progress”
c) If “% Complete” is blank or 0, the status is “Not Started”
Note: The “status” column is auto-calculated and has been blocked to avoid inconsistencies. When you insert new rows, these formulas are automatically populated.