IF(IS BLANK) - Multiple yes no criteria

I am trying to find a way to have this function look at 4 different cells and if any of them are not blank, it want it it say, "yes." If they are all blank, i want it to say, "no." I guess I need 4 of these strung together with OR. But I can't make it work:

=IF(ISBLANK([Outstanding Audit]@row), "No", "Yes")



  • Michelle Lempert
    Michelle Lempert ✭✭✭
    edited 03/16/23

    This is what I currently have, but it doesn't work unless there's data in all four cells:

    =IF(OR([Outstanding Audit]@row <> ""), IF(OR([Outstanding Tax]@row <> ""), IF(OR([Outstanding Insurance]@row <> ""), IF(OR([Outstanding Quarterly Rent Rolls]@row <> ""), "yes", "no"))))

  • J Tech
    J Tech ✭✭✭✭✭

    Hi @Michelle Lempert

    Your current formula uses nested IF statements and checks if each of the four cells has data before returning "yes". If any of the cells are empty, it will return "no". However, since you want to check if any of the cells have data, you should use the OR function for each cell check instead of the IF function.

    Here's an updated formula that should work for your requirement:

    =IF(OR([Outstanding Audit]@row <> "", [Outstanding Tax]@row <> "", [Outstanding Insurance]@row <> "", [Outstanding Quarterly Rent Rolls]@row <> ""), "yes", "no")

    This formula checks if any of the four cells have data using the OR function and returns "yes" if there is data in any of the cells, otherwise it returns "no".


    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!