IF & ISBlank Function

Shann Omuto
Shann Omuto ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to test whether or not the score inputted is greater than 80 or less than 80.

If the score is greater than 80 , I would like my status column to populate with a string labeled "Passed".

If the score is less than 80 I would like my status column to populate with a string labeled "Failed".

Heres the issue, I am unable to account for blank columns. My hope is to nest the ISBLANK function inside of the if statement, to prevent the function from reading blank cells as a "Failed".

Is this possible?

See image & function I am currently using below:

=IF(Score2 < 80, "Failed", "Passed")




  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭


    You could try:

    =IF(ISBLANK(Score2), "", IF(Score2 < 80, "Failed", "Passed"))

    Worked for me

    Kind regards

    Debbie Sawyer Consultant & Training Manager



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Try this nested IF statement that checks for blank scores and keeps the field blank. I also updated your formula to work in any row. 

    =IF(ISBLANK(Score@row), "", IF(Score@row < 80, "Failed", "Passed"))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!