IF/AND Formula help please

I am trying to create a formula that says if all 4 cells are blank it returns the text "NOT YET ALLOCATED". If the allocated start date has been completed, but the other 3 cells are blank, the text returns "MISSED", otherwise the cell should remain blank.

I have entered the following formula, but am getting the error #UNPARSEABLE.

=IF(AND(ISBLANK([Allocated Start Date]@row), ISBLANK([Completed By]@row), ISBLANK(Status@row), ISBLANK([Completed Date]@row), ISBLANK([Allocated Start Date]@row) "NOT YET ALLOCATED"), IF(AND(ISBLANK([Completed By]@row), ISBLANK(Status@row), ISBLANK([Completed Date]@row), TODAY() > [Allocated start Date plus 3 days]@row, "MISSED")), " ")

Find more posts tagged with

Accepted answers

All comments

JamesB

@Nikki_85

You are close. You need to close your AND Statement, to get to your TRUE argument. Try the edit below...

=IF(AND(ISBLANK([Allocated Start Date]@row), ISBLANK([Completed By]@row), ISBLANK(Status@row), ISBLANK([Completed Date]@row), ISBLANK([Allocated Start Date]@row)),"NOT YET ALLOCATED", IF(AND(ISBLANK([Completed By]@row), ISBLANK(Status@row), ISBLANK([Completed Date]@row), TODAY() > [Allocated start Date plus 3 days]@row), "MISSED", " "))

Nikki_85

Amazing!! thank you so much!

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.