Need Formula Help Multiple Date Columns, count days, if blank choose other column

Geilisa ✭✭✭
edited 08/24/22 in Formulas and Functions

I have Multiple date columns for approvals. I want to find the number of days between columns, but some are blank so I need it to choose another date column based on what I set. I've included example data.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!