# 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.

• ✭✭✭✭✭✭

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))

• ✭✭✭✭✭✭

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))

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

It works!

Thank you for helping out

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!