Duration Formula, if End Date is Blank, use Today's Date, if not, use End Date @ row


I'm struggling to update an existing formula in our Smartsheets. Currently, we calculate the duration of a task by using this formula:

=([End Date]@row - [Start Date]@row)

The issue is, if the end date is blank because the task is not complete, the duration is blank. I'd like to update it to use the existing formula AND if the end date is blank, use today's date.

I've hit a dead end every way I can think of to google this. Any help is appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!