IF AND and ISBLANK on multiple columns Formula help

Brenda Gonzales

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

Heather Duff

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!

Best,

Heather

Heather Duff

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!

Best,

Heather

Brenda Gonzales

Thank you so much. This worked.

=IF(COUNT([Date Requested]@row:[Revision Received]@row) = 7, "Complete", "Incomplete") . I had a duplicate. 😃

Heather Duff

@Brenda Gonzales Fantastic! So glad it worked.