Forum Discussion

Copper Contributor

Mar 10, 2023

If/Then ISBLANK in SharePoint Online Calculated Column

Hello, I have a calculated column I've called "FailPass" that needs to look across a series of choice columns to calculate a score, but also account for blanks. The below formula saves as a pas...

Lists

SharePoint Online

ganeshsanap
Mar 20, 2023
CristinaMorales Try formula like:

=IF(OR(ISBLANK([question 1?]),ISBLANK([question 2?]),ISBLANK([question3?]),ISBLANK([question 4?]),ISBLANK([question 5?]),ISBLANK([question 6?]),ISBLANK([question 7?]),ISBLANK([Question 8?])),"",IF(OR([question1.?]="Inaccurate",[question 2?]="Inaccurate",[question 3?]="Inaccurate"),"Fail","Pass"))

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

CristinaMorales

Copper Contributor

Hello, ganeshsanap this is what I've been trying to get to work with no success. Only certain questions should result in a "fail" if they are inaccurate, otherwise they "pass". I do not want a result to show until all questions are answered.
=IF(OR([question1.?]="Inaccurate",[question 2?]="Inaccurate",[question 3?]="Inaccurate"),"Fail","Pass",IF(OR(ISBLANK([question 1?]),ISBLANK([question 2?]),ISBLANK([question3?]),ISBLANK([question 4?]),ISBLANK([question 5?]),ISBLANK([question 6?]),ISBLANK([question 7?]),ISBLANK([Question 8?]))," ","Pass")

ganeshsanap

MVP

Mar 20, 2023

CristinaMorales Try formula like:

=IF(OR(ISBLANK([question 1?]),ISBLANK([question 2?]),ISBLANK([question3?]),ISBLANK([question 4?]),ISBLANK([question 5?]),ISBLANK([question 6?]),ISBLANK([question 7?]),ISBLANK([Question 8?])),"",IF(OR([question1.?]="Inaccurate",[question 2?]="Inaccurate",[question 3?]="Inaccurate"),"Fail","Pass"))

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

CristinaMorales
Copper Contributor
Mar 30, 2023
This worked. Thank you so much.