If Cell is not blank, equal date from different cell

I need the minds of the collective community!

I am trying to create a formula that states:

If "BCR Initial Approved Date" is not blank, then use date from "Estimated SFS date" or If "BCR Initial Approved Date" is Blank, leave blank.

Attached is my attempt at creating the formula but it give me an Incorrect Argument set.

Appreciate any help you can provide.

Jennifer

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Hi @Jennifer Rockwell ,

Try:

IF(ISDATE([BCR initial approve date]@row), [Estimated SFS date]@row, "")

Mark

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.