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

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.
Answers

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 358 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!