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
-
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
Answers
-
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
-
Thank you so much. This worked.
=IF(COUNT([Date Requested]@row:[Revision Received]@row) = 7, "Complete", "Incomplete") . I had a duplicate. 😃
-
@Brenda Gonzales Fantastic! So glad it worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!