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

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

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!