Can Isblank be used for more than one cell?

Charlene Stacy
Charlene Stacy ✭✭✭✭✭

I want to show if a column/cell is blank. I've used the formula =IF(ISBLANK([Tutor Name]@row), "Not Complete", "Complete") It works for one cell/column, however I have a range of 5 cells/columns.

How do I connect the formula to return a Complete or Incomplete---all cells need to have data to return "Complete" and if any cell is blank the value should be "Not Complete".

Best Answer

  • Cody Holmes
    Cody Holmes ✭✭✭✭
    edited 04/22/21 Answer βœ“

    Hi Charlene,

    There is probably a simpler way to do this, but I would probably handle it this way:

    =IF(AND(NOT(ISBLANK([Column1]@row)), NOT(ISBLANK([Column2]@row)), NOT(ISBLANK([Column3]@row)), NOT(ISBLANK([Column4]@row)), NOT(ISBLANK([Column5]@row))), "Complete", "Not Complete")

    Try this out and let me know if it works. If it does, be sure to accept it as a solution so that others who may have a similar question can find the answer. And give me a vote up if I proved helpful. πŸ‘

    P.S. Keep in mind that if you ever add a Column6... etc. You will have to add those into the AND condition with the same NOT(ISBLANK(...)) test.

    Edit: I have added a picture of a formatted formula so that you can better understand the logic of it.

    image.png


Answers

  • MCorbin
    MCorbin Overachievers Alumni

    Try this:

    =IF(AND(NOT(ISBLANK([Column1]@row)), NOT(ISBLANK([Column2]@row)), NOT(ISBLANK([Column3]@row)), NOT(ISBLANK([Column4]@row)), NOT(ISBLANK([Column5]@row))), "Complete", "Not Complete")

  • Cody Holmes
    Cody Holmes ✭✭✭✭
    edited 04/22/21 Answer βœ“

    Hi Charlene,

    There is probably a simpler way to do this, but I would probably handle it this way:

    =IF(AND(NOT(ISBLANK([Column1]@row)), NOT(ISBLANK([Column2]@row)), NOT(ISBLANK([Column3]@row)), NOT(ISBLANK([Column4]@row)), NOT(ISBLANK([Column5]@row))), "Complete", "Not Complete")

    Try this out and let me know if it works. If it does, be sure to accept it as a solution so that others who may have a similar question can find the answer. And give me a vote up if I proved helpful. πŸ‘

    P.S. Keep in mind that if you ever add a Column6... etc. You will have to add those into the AND condition with the same NOT(ISBLANK(...)) test.

    Edit: I have added a picture of a formatted formula so that you can better understand the logic of it.

    image.png


  • AndrΓ©e StarΓ₯
    AndrΓ©e StarΓ₯ Community Champion

    Hi @Charlene Stacy

    I hope you're well and safe!

    To add to previous excellent advice/answer.

    Here's another option. I prefer this structure because it's less to type. πŸ˜‰

    =IF(AND([Column1]@row <> ""; [Column2]@row <> ""; [Column3]@row <> ""; [Column4]@row <> ""; [Column5]@row <> ""); "Complete"; "Not Complete")

    Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD

    βœ…Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!