IF AND and ISBLANK on multiple columns Formula help

Scenario: If any of the columns have a blank Status is "Incomplete" . Only when all columns are filled and have values, status is "Complete" .

=IF(ISBLANK([Date Requested]@row), "Incomplete")

=IF(ISBLANK([Item Category]@row), "Incomplete")

=IF(ISBLANK([Customer #]@row), "Incomplete")

=IF(ISBLANK([Item Number]@row), "Incomplete")

=IF(ISBLANK([Item Number]@row), "Incomplete")

=IF(ISBLANK([Updated Pricing]@row), "Incomplete")

=IF(ISBLANK([Date Requested]@row), "Incomplete"

=IF(ISBLANK([Revision Received]@row), "Incomplete")

Only when all columns have a value need to change status to complete. Please help . Thank you

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi @Brenda Gonzales ,

    I may be oversimplifying this, but I'm hoping it will help. IF (and only if) the columns are all adjacent to one another, you could set the column formula to this:

    =IF(COUNT([Date Requested]@row:[Revision Received]@row)=8,"Complete","Incomplete")

    This translates to: if there are 8 values to count between date requested and revision received, mark complete; otherwise, mark incomplete.

    Let me know if it works for you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!