sharepoint online : calculated column

Question

sharepoint online : calculated column

Mustapha Ait Bencheikh 41

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 :

1 answer

Your answer

Answer 1

Allen Xu_MSFT 13,891

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:

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.

Mustapha Ait Bencheikh 41 Reputation points

2021-04-22T09:43:01.223+00:00

Hi,
I used the formula but didn't work for me.
Allen Xu_MSFT 13,891 Reputation points

2021-04-22T09:47:28.86+00:00

@Mustapha Ait Bencheikh ,

What are the column names in your list? Are they also Statut P.O and Statut HR?
Mustapha Ait Bencheikh 41 Reputation points

2021-04-22T10:15:37.03+00:00

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"))))
Allen Xu_MSFT 13,891 Reputation points

2021-04-23T01:32:58.83+00:00

@Mustapha Ait Bencheikh ,

Check the column name spelling in the formula. If the error still exists, try to delete the calculated column and recreate a new one.
Mustapha Ait Bencheikh 41 Reputation points

2021-04-23T09:01:45.893+00:00

No still the same error ! I don't know why ?!

Allen Xu_MSFT 13,891

@Mustapha Ait Bencheikh ,

Try to use the below PnP PowerShell command:

#Parameter  
$SiteURL = "https://xxx.sharepoint.com/sites/xxx"  
$ListName= "xxx"  
    
#Connect to PnP Online  
Connect-PnPOnline -Url $SiteURL -UseWebLogin  
   
#Add a calculated column to list  
Add-PnPField -List $ListName -Type Calculated -InternalName "xxx" -DisplayName "xxx" -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"))))"

Share via

sharepoint online : calculated column

1 answer

Your answer