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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!