Conditional Formula with Date requirment

Ryan Jared

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?

Mark Cronk

Hi @Ryan Jared

Try

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

Work?

Mark

Mark Cronk

Hi @Ryan Jared

Try

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

Work?

Mark

Ryan Jared

That worked, thank you!!