Combined Formulars

I was planning to have this Formular incorporated in our sheets, however I can’t find a way to accomplish this:

The basic Formular is used to set a cell to either "1" or "0":

IF(AND([Contract Date]7 - TODAY() <= 2, NOT(Status7 = "N/A"), NOT(Status7 = "Not Scheduled"), NOT(Status7 = "Completed")), 1, 0)

But,

Since “Contract Date” is blank until the date has been established, it will set the cell to "1" when no date is entered.

We don't want that!

Is it possible to bypass the execution until a date has been entered?

Sample:

IF [Contract Date]7 is not blank

Then Execute this

IF(AND([Contract Date]7 - TODAY() <= 2, NOT(Status7 = "N/A"), NOT(Status7 = "Not Scheduled"), NOT(Status7 = "Completed")), 1, 0)

Else

Bypass.

Find more posts tagged with

Accepted answers

Nic Larsen

Try this: =IF(ISBLANK([Contract Date]@row), "", IF(AND([Contract Date]@row - TODAY() <= 2, NOT(Status@row = "N/A"), NOT(Status@row = "Not Scheduled"), NOT(Status@row = "Completed")), 1, 0))

All comments

Nic Larsen

Try this: =IF(ISBLANK([Contract Date]@row), "", IF(AND([Contract Date]@row - TODAY() <= 2, NOT(Status@row = "N/A"), NOT(Status@row = "Not Scheduled"), NOT(Status@row = "Completed")), 1, 0))

Teamciccone30576

Newer seen that Function before - well there are probably more I don't know about.

It works!

Thank you for helping out

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.