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!

Find more posts tagged with

Formulas

Accepted answers

Katy H

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

All comments

Katy H

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.

Tristan

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

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

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

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.