I try to create a calculated column on SharePoint list but in everytime : error syntaxe ...
this is an explanation about my probleme if some one can help me :
I try to create a calculated column on SharePoint list but in everytime : error syntaxe ...
this is an explanation about my probleme if some one can help me :
Hi @MustaphaAitBencheikh-9124 ,
I used the formula below and worked perfectly in my end:
=IF([Statut P.O]="Pending P.O","Pending P.O",IF([Statut P.O]="Reject P.O","Reject P.O",IF([Statut HR]="Approve HR","Approved",IF([Statut HR]="Reject HR","Rejected","pending HR"))))
Test process:

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi,
I used the formula but didn't work for me.

What are the column names in your list? Are they also Statut P.O and Statut HR?
This is my formula: =IF([Statut approbation du responsable hiérarchique]="En Attente","En attente approbation responsable hiérarchique",IF([Statut approbation du responsable hiérarchique]="Rejeté","Approbation rejeté par responsable hiérarchique",IF([Statut approbation du responsable hiérarchique]="Approuvé","En attente approbation RH",IF([Statut approbation de la DRH]="Approuvé","Approuvé",IF([Statut approbation de la DRH]="Rejeté","Rejeté par RH","En Attente HR"))))
7 people are following this question.