Can Isblank be used for more than one cell?

04/21/21
Accepted

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 HolmesCody Holmes ✭✭✭✭
    edited 04/22/21 Accepted 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.


Answers

  • MCorbinMCorbin Overachievers

    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 HolmesCody Holmes ✭✭✭✭
    edited 04/22/21 Accepted 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.


  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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 PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.