Sharepoint online calculated columns

Mustapha Ait Bencheikh 41 Reputation points
2021-03-16T14:26:07.73+00:00

I created a calculated column to test if too other columns in the same list are empty (Blank), but my own formula didn't work I need help please !

78230-8.png

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,543 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Echo Du_MSFT 17,111 Reputation points
    2021-03-17T03:06:14.867+00:00

    Hello @Mustapha Ait Bencheikh ,

    Use the following formula to count the number of blank fields. 

    =IF(ISBLANK(Title),1,0)+IF(ISBLANK(ColumnA),1,0) + IF(ISBLANK(ColumnB),1,0)  
#When the value is 0, it means that no field is empty

    78543-1.png

    Thanks,
    Echo Du

    ====================
    Updated Answer ===================

    Hi @Mustapha Ait Bencheikh ,

    Please use the following formula: 

    =IF(OR(ISBLANK([DATE DE REMBOURSEMENT OU RETOUR]),ISBLANK([MONTANT REMBOURSE])),"Non Remboursé","Remboursé")

    78910-calculated-column.png

    78981-list.png

    Thanks,
    Echo Du

    ================

    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.

  2. Mustapha Ait Bencheikh 41 Reputation points
    2021-03-17T11:34:01.337+00:00

    @Echo Du_MSFT
    The code works finaly but this is not what I need, I need when the both fields or one of them empty return "Non Remboursé" else "Remboursé" is that possible becouse I tried to modify your code and still errors