Conditional Formula with Date requirment

Im having trouble combing a conditional formula. Both parts work on their own but when I try to join them it breaks.

So far this is what i have

=IF(AND([FINISH]1< [Go live Date]1), IF(Status1 = "In Progress", 1, IF(Status1 = "Not Started", 1, IF(Status1 = "At Risk", 1,0)))))

I'm trying to do a numerical count. If the Finish date is not past the Go live date and the status is either In progress, At Risk, or Not started then the formula should pull 1. If it does not fit these requirements than the formula should pull 0.

Any idea on what I'm doing wrong?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!