question

MustaphaAitBencheikh-9124 avatar image
0 Votes"
MustaphaAitBencheikh-9124 asked AllenXu-MSFT edited

sharepoint online : calculated column

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


office-sharepoint-onlineoffice-sharepoint-server-administrationoffice-sharepoint-server-developmentoffice-sharepoint-server-customization
probleme.png (16.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered AllenXu-MSFT edited

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:
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.


test.gif (1.1 MiB)
image.png (11.9 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
I used the formula but didn't work for me.

90160-3.png


0 Votes 0 ·
3.png (12.3 KiB)
AllenXu-MSFT avatar image AllenXu-MSFT MustaphaAitBencheikh-9124 ·

@MustaphaAitBencheikh-9124,

What are the column names in your list? Are they also Statut P.O and Statut HR?
90170-image.png


0 Votes 0 ·
image.png (14.3 KiB)

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"))))

90290-4.png


0 Votes 0 ·
4.png (16.3 KiB)
Show more comments