Populating a new column using an IF statement

Tess Waresmith

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))

Tess Waresmith

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

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!