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 !
Hello @MustaphaAitBencheikh-9124 ,
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
==================== Updated Answer ===================
Please use the following formula:
=IF(OR(ISBLANK([DATE DE REMBOURSEMENT OU RETOUR]),ISBLANK([MONTANT REMBOURSE])),"Non Remboursé","Remboursé")
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.
5 people are following this question.