Automatically Change the value of column

[nthnn060500]

Hello, how can i change the status column from "Not Completed" to "Completed"?

The idea is if every status is approved, it will automatically change to "Completed".

[lynchk21]

If I understand you correctly, try:

IF(AND([Status GH Data]="Approved",[Status User]="Approved",[Status President]="Approved",[Status Information]="Approved",[Status Others]="Approved"),"Approved","Not Approved")