Formula to populate date from another cell if blank

Hi,

I'm struggling with what feels like it should be a simple formula, so hoping the fabulous community can assist.

I need to copy the date from the Creation Date column to the Start Date column when it is blank and leave the existing date if it not blank.

All the formula's I've tried either give me a circular error or overwrite the existing date in the Start Date column.

This is the result I'm trying to get with a column formula (rather than manual entry or cell formula).

Any help would be appreciated!

Find more posts tagged with

Formulas

Accepted answers

EvanShortreed

Good Morning,

I would add in a helper column to apply this formula

=IF(ISBLANK([Start Date]@row), [Creation Date]@row, [Start Date]@row)

Add in a helper column named: "Manual Date Input". This is where you would put in your manual dates like you have shown above. From there, your "Start Date" Column would have this formula in it to run the logic.

All comments

EvanShortreed

Good Morning,

I would add in a helper column to apply this formula

=IF(ISBLANK([Start Date]@row), [Creation Date]@row, [Start Date]@row)

Caroline Elliott

Thanks for the help @EvanShortreed unfortunately I'm still getting a #circular reference error using that formula and adding in the helper column as suggested.

Caroline Elliott

Scratch that. It worked! I had the formula in the wrong start date column instead of the helper column. Works perfecting now. Thank you so much @EvanShortreed

EvanShortreed

Good Morning @Caroline Elliott,

If you need anything else, don't hesitate to reach out to us.

https://www.entheosstudio.com/

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.