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([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

Find more posts tagged with

Accepted answers

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.