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
-
Try
=IF(ISDATE([Date 2]@row), [Date 2]@row, [Date 1]@row)
Answers
-
Try
=IF(ISDATE([Date 2]@row), [Date 2]@row, [Date 1]@row)
-
I was so close to having it correct, that worked perfectly. Thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!