If and ISText formula

Archie077 You need to build your formula, starting with the last criteria. If "valid" and all other cells contain text, then "Closed" and so on. If you don't do that, once the third condition is met it will always  returns "in progress" and never evaluate the last three IF statements. You may also consider using IFS. That would then look something like this:

=IFS(logic6,"closed",logic5,"reopen",logic4,"assigned",logic3,"in progress",logic2,"closed",logic1,"new")

Not convinced though that this is the most effective way to achieve your ultimate goal. Would need to see your actual schedule to recommend possible alternatives.