sharepoint online : calculated column

Mustapha Ait Bencheikh 41 Reputation points
2021-04-21T13:49:33.197+00:00

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 :
89966-probleme.png

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,221 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,626 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,573 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,799 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Allen Xu_MSFT 13,776 Reputation points
    2021-04-22T04:07:16.42+00:00

    Hi @Mustapha Ait Bencheikh ,

    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:
    90215-test.gif
    90216-image.png

    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.