Combine if ISBLANK in an existing formula that pulls percent complete based on duration

I have the formula that pull the percentage complete based on the duration between 2 dates

=IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, MIN(TODAY(), [End Date]@row)) / Duration@row, 0)

What I'm trying to do is add the formula below to make a combined formula. Which should make the number zero if there is no date added.

=IF(ISBLANK([Start Date]@row), "0")

Any thoughts?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!