Collecting a date value if not blank

Options

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.


Best Answer

  • Summer
    Summer ✭✭✭
    edited 04/26/22 Answer ✓
    Options

    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.


Answers

  • Summer
    Summer ✭✭✭
    edited 04/26/22 Answer ✓
    Options

    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
    Options

    @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
    Summer ✭✭✭
    Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!