IF / COUNTIF / Blank cell

Options

I am using the below formula but when my reference sheet has a blank cell the formula returns a Yes. I need for it to return a blank cell.

=IF(COUNTIF({Option Exception Master List}, Account@row) > 0, "Yes", "No")

Answers

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    edited 05/12/23
    Options

    Hello @C. Perry,

    This will populate a "Yes" if there's a blank.

    =IF(AND(COUNTIF({Option Exception Master List}, Account@row) > 0, ISBLANK(Account@row) = TRUE), "Yes", "No")

    This will populate a blank if there's a blank:

    =IF(AND(COUNTIF({Option Exception Master List}, Account@row) > 0, ISBLANK(Account@row) = TRUE), "", "No")

  • C. Perry
    C. Perry ✭✭✭
    Options

    My Account@row sheet is referencing {Option Exception Master List} and if Account@row sheet is on the reference sheet I need it to return Yes and if not no. If the Account@row sheet is blank I need it to return blank. Doe not look like your comments prior will allow this. Can you provide a good formula to do this.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!