Populating a new column using an IF statement

Hi all, I have two columns of dates and want to combine them in the 3rd column based on an if rule. If column 2 is blank I want to pull in the date from column 1, otherwise I want to pull in the date from column 2. Can someone help me format this? Thank you! I was thinking of ISBLANK function but it didn't work for me. This is what I tried: =IF(ISBLANK([Start Date]5, [Assumed Start Date]5, [Start Date]5))

Find more posts tagged with

Accepted answers

Tess Waresmith

I just figured it out! The 3rd column wasn't formatted as DATE. Please disregard. Thanks!

All comments

Tess Waresmith

I just figured it out! The 3rd column wasn't formatted as DATE. Please disregard. Thanks!

Genevieve P.

Hi Tess,

Glad to hear you got it working!

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.