Help with creating Formula's using " Is Blank" and "If"
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!
Best Answer

@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?
Answers

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.

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!

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"

@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?
Help Article Resources
Categories
Check out the Formula Handbook template!