Help with creating Formula's using " Is Blank" and "If"

Options

So, for the first part of the equation, I wanna say " if the contract end date is blank, then the decision date cell will be blank"

and the second part of the equation is the decision date column = (Contract End date minus Notice Period)

=IF(ISBLANK(Contract End Date@row),COUNTIF([Contract End Date]@row - [Renewal Alert Date]@row)

I tried combining the two formulas, but I keep getting an error. Can somebody point out what I did wrong?

Thanks in advance!

Tags:

Best Answer

  • Katy H
    Katy H ✭✭✭✭✭✭
    Answer ✓
    Options

    @Brittany Marie There are still some issues with your syntax (apologies for including bad syntax in my earlier response!)

    Try this:

    =IF(ISBLANK([Contract End Date]@row),"",([Contract End Date]@row, [Renewal Alert Date]@row))

    I think the countif is actually not needed? Are you just trying to subtract one date from the other to get the number of days?

    Katy Hall

    Head of Product Management

    ILLA Canna

    LinkedIn

Answers

  • Katy H
    Katy H ✭✭✭✭✭✭
    Options

    Assuming the formula is located in the "Decision Date" column, try the formula below.


    =IF(ISBLANK(Contract End Date@row),"", COUNTIF([Contract End Date]@row - [Renewal Alert Date]@row))


    Syntax translates to if Contract End Date is blank, then make the Decision Date blank, if not then subtract renewal alert date from contract end date.

    Katy Hall

    Head of Product Management

    ILLA Canna

    LinkedIn

  • Tristan
    Tristan
    edited 04/11/22
    Options

    Brittany,

    =IF(ISBLANK([Contract End Date@row]),"",COUNTIF([Contract End Date]@row - [Renewal Alert Date]@row))

    Try that.

    You need the [ ] Brackets around the first [Contract End Date]@Row. And a second ) at the end.

    The IF formula works like this: IF(the check, if true do this, if false do this) You can use two quotes to signify nothing.

    You could also write it as this:

    =IF([Contract End Date]@row="","",COUNTIF([Contract End Date]@row - [Renewal Alert Date]))

    Hope this helps!

  • Brittany Marie
    Options

    Hi Katy and Tristan,

    Thanks for your quick response

    So, I tried plugging in the formula: =IF(ISBLANK([Contract End Date@row]),"",COUNTIF([Contract End Date]@row - [Renewal Alert Date]@row))

    But, I keep getting the " Unparseable"

  • Katy H
    Katy H ✭✭✭✭✭✭
    Answer ✓
    Options

    @Brittany Marie There are still some issues with your syntax (apologies for including bad syntax in my earlier response!)

    Try this:

    =IF(ISBLANK([Contract End Date]@row),"",([Contract End Date]@row, [Renewal Alert Date]@row))

    I think the countif is actually not needed? Are you just trying to subtract one date from the other to get the number of days?

    Katy Hall

    Head of Product Management

    ILLA Canna

    LinkedIn

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!