Formula Help Needed!!!
I have a formula that works for when a finish@row date is less than the specific target date (Finish21) and the Status is not in (In Progress, Not Started, or At Risk) than the cell count should be 1.
However I'm struggling with adding the function to this formula that states IF the Finsh@row is Blank than the count should be 0. Any suggestions? Below is the formula I have.
=IF(AND(Finish@row < Finish21, OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "At Risk")), 1, 0)
Best Answer

Could it be as simple as just doing this to the formula ...
=IF(Finish@row = "", 0, (formula that you already have above)
=IF(Finish@row = "", 0, (IF(AND(Finish@row < Finish21, OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "At Risk")), 1, 0)
Hope this helps!
Heath Hilton
Answers

Could it be as simple as just doing this to the formula ...
=IF(Finish@row = "", 0, (formula that you already have above)
=IF(Finish@row = "", 0, (IF(AND(Finish@row < Finish21, OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "At Risk")), 1, 0)
Hope this helps!
Heath Hilton

That did the trick, thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!