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

Options
Geilisa
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.

image.png


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!