Multiple IF AND ISBLANK Criteria in Formula
What I'm trying to accomplish:
 If [Approved] is checked, change [Status] to "Complete"
 If [Ad RSS Link], [Subject Line], and [Done] are not blank, change [Status] to "Proofing"
 If [Ads Entered] is checked, change [Status] to "Proofing"
 If none of the above are true, [Status] will be "Waiting for Information"
Here is the formula I'm using, but it keeps coming back as UNPARSEABLE. I've looked it over and retyped it a few times to no avail. Am I missing something?
=IF(NOT(ISBLANK([Approved@row])), "Complete", IF(AND(NOT(ISBLANK([Ad RSS Link]@row)), NOT(ISBLANK([Done]@row)), NOT(ISBLANK([Subject Line]@row)), "Proofing", IF(NOT(ISBLANK([Ads Entered]@row)), "Proofing", "Waiting for Information"))))
Thank you so much for the help and insight!
Best Answer

Try this:
=IF(Approved@row = 1, "Complete", IF(OR([Ads Entered]@row = 1, AND([Ad RSS Link]@row <> "", [Subject Line]@row <> "", Done@row <> "")), "Proofing", "Waiting For Information"))
The two issues I see with your formula are:
 Your first cell reference has a misplaced square bracket after "@row" instead of after the column name.
 You have a closing parenthesis at the very end of the formula that needs to be moved to NOT(ISBLANK([Subject Line]@row)) so that it closes out the AND statement.
Answers

Try this:
=IF(Approved@row = 1, "Complete", IF(OR([Ads Entered]@row = 1, AND([Ad RSS Link]@row <> "", [Subject Line]@row <> "", Done@row <> "")), "Proofing", "Waiting For Information"))
The two issues I see with your formula are:
 Your first cell reference has a misplaced square bracket after "@row" instead of after the column name.
 You have a closing parenthesis at the very end of the formula that needs to be moved to NOT(ISBLANK([Subject Line]@row)) so that it closes out the AND statement.

That worked perfectly. Thank you so much!

At first glance, if you're using a 'Check' field for [Approved], you first condition in your if statement should look for a 1 or 0:
IF([Approved]@row = 1, "Complete".........

@Alan P. You can still use the NOT(ISBLANK(.......)) for a checkbox type column. It may require a little more typing, but it still works. You can also use true for checked and false for unchecked since it is boolean.


Yeah I knew that logically, a NOT(IS BLANK will work, but I preferred to use the truncated logic of the boolean 1 and 0. Easier on the eyes and makes it a lot easier to explain if Megan wanted to share with another user onsite.
All in all, an unanswered question is answered :)

@Alan P. I agree that using 1 vs 0 is much easier to read/manage.
The way I read your comment though, it seemed (to me at least) that you were suggesting that was the actual problem with the formula and not necessarily a "personal preference" type of suggestion.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!