Pulling a date based on if a field is blank


I have 2 columns of data, [Date1] and [Date2].

[Date2] is sometimes blank.

I want to create a new column of data that shows [Date2] if not blank, and [Date1] if blank.

Can someone help me create the correct formula for this? I guessed that I would need an IF formula with a ISBLANK within, but I'm having trouble with how to assign my results.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!