How is the status field calculated?

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
 
Image showing the different status options
 

 

 

 

 

 

 

 

Note: The “status” column is auto-calculated and has been blocked to avoid inconsistencies. When you insert new rows, these formulas are automatically populated.