Forum Discussion

CristinaMorales's avatar
CristinaMorales
Copper Contributor
Mar 10, 2023
Solved

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's avatar
    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

ganeshsanap's avatar
ganeshsanap
MVP
Mar 10, 2023

CristinaMorales You can use formula in this format: 

 

=IF(OR(ISBLANK([Column 1]),ISBLANK([Column 2]),ISBLANK([Column 3]),ISBLANK([Column 4]),ISBLANK([Column 5])),"",<Replace this with your existing formula>)

 

<Replace this with your existing formula> replace this section with your existing formula which you are using for calculation.

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

Resources