Collecting a date value if not blank

Spencor_Luze

I am trying to combine two columns into one. The only way I can think of doing this is with an IF formula. what I have is

=IF([Ready for Final Review Initial]@row = 0, [Ready for Final Review Reapp]@row, [Ready for Final Review Initial]@row)

It works for collecting my secondary value, but does not work for the initial column if not blank. All three columns properties are date value.

Summer

Hi @Spencor_Luze

When you say combine two columns, you don't mean have both dates in one column right? Based on your initial formula it looks like you want to pull the date from the "Ready for Final Review Initial" column and if that column is blank, to pull the date in the "Ready for Final Review Reapp" column instead.

If that's correct, try this

=IF(ISBLANK([Ready for Final Review Initial]@row), [Ready for Final Review Reapp]@row, [Ready for Final Review Initial]@row)

Because your "Ready for Final Review Initial" column is a date having a 0 doesn't make sense. So the formula has been updated to say if the column is blank then return the value in the "Ready for Final Review Reapp" column, if it's not blank than return the value in the "Ready for Final Review Initial" column.

Summer

Hi @Spencor_Luze

When you say combine two columns, you don't mean have both dates in one column right? Based on your initial formula it looks like you want to pull the date from the "Ready for Final Review Initial" column and if that column is blank, to pull the date in the "Ready for Final Review Reapp" column instead.

If that's correct, try this

=IF(ISBLANK([Ready for Final Review Initial]@row), [Ready for Final Review Reapp]@row, [Ready for Final Review Initial]@row)

Because your "Ready for Final Review Initial" column is a date having a 0 doesn't make sense. So the formula has been updated to say if the column is blank then return the value in the "Ready for Final Review Reapp" column, if it's not blank than return the value in the "Ready for Final Review Initial" column.

Spencor_Luze

@Summer

Shoot, I even tried the ISBLANK function but apparently did not have enough coffee that morning. This makes sense and is working properly.

Summer

@Spencor_Luze The coffee thing is super relatable. I'm glad it's working for you now.