# 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?

Tags:

• ✭✭✭✭✭✭

You would drop the first IF in the third portion of the second IF to create a nest IF statement.

=IF(logical statement, value if true, value if false)

Basically you want it to run the first logical statement. If that is true then you have your output. If the first logical statement is false then you want to run another IF statement.

• ✭✭✭✭✭✭

You would drop the first IF in the third portion of the second IF to create a nest IF statement.

=IF(logical statement, value if true, value if false)

Basically you want it to run the first logical statement. If that is true then you have your output. If the first logical statement is false then you want to run another IF statement.

• That did the trick, Thanks @Paul Newcome

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!