Populating a new column using an IF statement

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!