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".
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")
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
12 |