How to express this condition in SharePoint Calculated field?

A field should have a result of yes or no with below condition:

If ALL the fields value is completed answer should be No, else Yes.

  • Do you mean set value to "No" if all list form fields entered by user (when there is no blank field)? Or when list column has value = "completed", set calculated column value to "No". Commented Dec 19, 2022 at 11:09

2 Answers 2


Try below formula


1.If you want to set the calculated column value to No when all fields have no blank fields, use this formula:


The running result realizes that when both column1 and number1 have values, No is displayed, otherwise Yes. enter image description here

2.If you want to set the calculated column value to No when column has value = "completed", use this formula:


If the answer is helpful, please click "√" on the left panel of the answer and kindly upvote it.

  • Hi @jeanggerr,I am checking the status of this case. Please let us know if you would like further assistance. If you have any update about this issue, please feel free to post back.
    – Xyza_MSFT
    Commented Jan 2, 2023 at 1:41
  • Did my response answer your question? If I misunderstand something, please let me know! If there is any other assistance i can provide, please feel free to let me know, i will do our best to help you.
    – Xyza_MSFT
    Commented Jan 5, 2023 at 6:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.