Pulling a date based on if a field is blank

I have 2 columns of data, [Date1] and [Date2].

[Date2] is sometimes blank.

I want to create a new column of data that shows [Date2] if not blank, and [Date1] if blank.

Can someone help me create the correct formula for this? I guessed that I would need an IF formula with a ISBLANK within, but I'm having trouble with how to assign my results.

Find more posts tagged with

Accepted answers

Try

=IF(ISDATE([Date 2]@row), [Date 2]@row, [Date 1]@row)

All comments

Try

=IF(ISDATE([Date 2]@row), [Date 2]@row, [Date 1]@row)

I was so close to having it correct, that worked perfectly. Thank you!

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