Nested IF's with blank cells.

Good afternoon Community!

I'm working on a formula that will Assign a "New" or "Old" Cost center based on a date field. I have this functioning properly using the following formula:

=IF([Transaction Date]@row < DATE(2023, 3, 31), "Old - Cost Center", "New - Cost Center")

Now, I am trying to add in a feature that will leave the cost center field blank if [Transaction Date] is blank. I've tried nesting If's and using ISBLANK without any luck.

tyty

Find more posts tagged with

Accepted answers

DKazatsky2

Hi @Coen ,

Give this a try.

=IF(ISBLANK([Transaction Date]@row), "", IF([Transaction Date]@row < DATE(2023, 3, 31), "Old - Cost Center", "New - Cost Center"))

Hope that helps,

Dave

All comments

DKazatsky2

Hi @Coen ,

Give this a try.

=IF(ISBLANK([Transaction Date]@row), "", IF([Transaction Date]@row < DATE(2023, 3, 31), "Old - Cost Center", "New - Cost Center"))

Hope that helps,

Dave

Coen

Dave! Thank you so much, this did the trick!!

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.