Formula Needed. - IF Blank, then Index another cell

Hi,

I am looking for some help with a formula. I need a formula that will "pull/copy" the date entered in the column titled REV. START DATE. However, if the REV. START DATE is blank, then I need it to pull the date from the ORIGINAL START DATE column located on the same row. I was originally using the =MAX([Original Start Date]@row, [Rev. Start Date]@row).....however, I forgot that sometimes, the revised date is prior to the original start date. I have provided a screenshot for reference. Any suggestions are appreciated!

Please help :)

Find more posts tagged with

Accepted answers

JamesB

@Allison Bishop

This formula should get you what you need.

=IF(ISBLANK([Rev. Start Date]@row), [Original Start Date]@row, [Rev. Start Date]@row)

All comments

JamesB

@Allison Bishop

This formula should get you what you need.

=IF(ISBLANK([Rev. Start Date]@row), [Original Start Date]@row, [Rev. Start Date]@row)

Allison Bishop

@JamesB, thank you! I think this is it!!!!

Andrée Starå

https://community.smartsheet.com/discussion/108937/formula-needed-if-blank-then-index-another-cell

Hi,

I hope you're well and safe!

To add to James's excellent answer/advice.

Here's another option. (the one I personally prefer because it's shorter)

=IF([Rev. Start Date]@row="", [Original Start Date]@row, [Rev. Start Date]@row)

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

JamesB

@Allison Bishop Your wlecome.

Mike King

Im getting #Circular Reference when using both of the suggested formulas above. Any suggestions?

TracyJohnson

Same issue as Mike, get a circular reference error

=IF(Subcategory@row = "", [Task Type]@row, Subcategory@row)

Same with all the other variations I've tried that were marked as correct. Did something change?

Genevieve P.

Hi @TracyJohnson

Can you clarify what column you're inputting the formula into? Note that it can't be either "Subcategory" or "Task Type" because you're referencing those. Does that make sense?

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.