question

MustaphaAitBencheikh-9124 avatar image
0 Votes"
MustaphaAitBencheikh-9124 asked EchoDu-MSFT commented

Sharepoint online calculated columns

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


office-sharepoint-online
8.png (28.2 KiB)
· 3
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 @MustaphaAitBencheikh-9124 ,

Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

0 Votes 0 ·

Hi @MustaphaAitBencheikh-9124 ,

Have you tried the solution I proposed? If you have any questions or progress, you can contact me in time.

Looking forward to your reply.

Have a lucky day!

0 Votes 0 ·

Hi @MustaphaAitBencheikh-9124 ,

Can you tell me whether your issue has been resolved or have any update?

I am looking forward to your reply.

0 Votes 0 ·
EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT edited

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

78543-1.png


Thanks,
Echo Du
==================== Updated Answer ===================

Hi @MustaphaAitBencheikh-9124 ,

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.




1.png (34.9 KiB)
list.png (14.4 KiB)
· 2
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.

@EchoDu-MSFT first of all Thank you for your help, I tried your solution but didn't work I don't no why !

78677-111.png


78711-2222.png


0 Votes 0 ·
111.png (30.3 KiB)
2222.png (10.5 KiB)
EchoDu-MSFT avatar image EchoDu-MSFT MustaphaAitBencheikh-9124 ·

Hi @MustaphaAitBencheikh-9124 ,

In my test, there was no similar error.

This may be because your Columns display name is too long, so you need to add square brackets [ ] .

 =IF(ISBLANK([DATE DE REMBOURSEMENT OU RETOUR]),1,0)+IF(ISBLANK([MONTANT REMBOURSE]),1,0)

78707-list.png

Thanks,
Echo Du


0 Votes 0 ·
list.png (8.8 KiB)
MustaphaAitBencheikh-9124 avatar image
0 Votes"
MustaphaAitBencheikh-9124 answered EchoDu-MSFT commented

@EchoDu-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

· 1
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 @MustaphaAitBencheikh-9124 ,

Thanks for your reply.

I have updated answer under initial My Answer. Hope this can help you to solve issue.

Have a nice day!

Thanks,
Echo Du
===================
You can directly click “Comment” option under ”My Answered“ to put forward your opinions and thoughts about solution that I propose.

1 Vote 1 ·