Formula Needed. - IF Blank, then Index another cell


I am looking for some help with a formula. I need a formula that will "pull/copy" the date entered in the column titled REV. START DATE. However, if the REV. START DATE is blank, then I need it to pull the date from the ORIGINAL START DATE column located on the same row. I was originally using the =MAX([Original Start Date]@row, [Rev. Start Date]@row).....however, I forgot that sometimes, the revised date is prior to the original start date. I have provided a screenshot for reference. Any suggestions are appreciated!

Please help :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!