IF AND OR not working properly, last IF not triggering anything

crystal.gonzalez.ND

Please help me figure out why this is not working:

=IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0), "Upcoming", IF(ISBLANK([Start Date]@row ), "Upcoming")))))

The last piece of the formula is not triggering a change to "Upcoming". If a date is greater than 61 days it does change the status to "Upcoming", but if Start Date is blank instead of changing to "Upcoming" it changes to "Not Started" and I am not sure why. Please help!

Find more posts tagged with

Sheets

Formulas

functionality

Project Management

Accepted answers

All comments

There are no accepted answers yet

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.