Combining IF AND NOT ISBLANK Function

Hi there,

Can anyone tell me what is wrong with my function below?

=IF(AND(ISBLANK([Date Submitted to SS]@row), ISBLANK([Date Enter/Update to RPM]@row)), "Empty", IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), ISBLANK([Date Enter/Update to RPM]@row)), "Half")),IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), NOT(ISBLANK([Date Enter/Update to RPM]@row)),"Full"))

Everything is fine up to the "Half")), but after I add in the 3rd function it become #UNPARSEABLE, I have tried moving brackets around still not working...

Thanks in advance!

Find more posts tagged with

Accepted answers

Zee Cheok

Got it now by taking off the ) after "Half".

=IF(AND(ISBLANK([Date Submitted to SS]@row), ISBLANK([Date Enter/Update to RPM]@row)), "Empty", IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), ISBLANK([Date Enter/Update to RPM]@row)), "Half", IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), NOT(ISBLANK([Date Enter/Update to RPM]@row))), "Full")))

Thank you very much!

David Tutwiler

Awesome!. Glad to see that this fixed it.

All comments

David Tutwiler

I believe you have an extra ) after "Half" that needs to be taken out:

=IF(AND(ISBLANK([Date Submitted to SS]@row), ISBLANK([Date Enter/Update to RPM]@row)), "Empty", IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), ISBLANK([Date Enter/Update to RPM]@row)), "Half"),IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), NOT(ISBLANK([Date Enter/Update to RPM]@row)),"Full"))

Zee Cheok

Got it now by taking off the ) after "Half".

=IF(AND(ISBLANK([Date Submitted to SS]@row), ISBLANK([Date Enter/Update to RPM]@row)), "Empty", IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), ISBLANK([Date Enter/Update to RPM]@row)), "Half", IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), NOT(ISBLANK([Date Enter/Update to RPM]@row))), "Full")))

Thank you very much!

David Tutwiler

Awesome!. Glad to see that this fixed it.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.