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

jess_roberts

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.

Thanks!

Paul Newcome

Try this:

=IF([End Date]@row <> "", [End Date]@row, TODAY()) - [Start Date]@row

Paul Newcome

Try this:

=IF([End Date]@row <> "", [End Date]@row, TODAY()) - [Start Date]@row

jess_roberts

@Paul Newcome TYSM!!! This is exactly what I needed. I can't thank you enough!!!

Paul Newcome

Happy to help. 👍️