Status Change within a Cell Formula where it moves it to the next stage if true

KHiatusInfinite

Below is what I need in a formula string to generate these items from a dropdown list within the cell.

Cancel WT = Yes, Status = Cancelled

If Demand Planning/AMT Input Complete (AMT) = True, Status = Finance to Add Cost

If Finance Input Complete (Finance) = True, Status = IC to Set Up TO

IF TO# (Inventory Control) is not blank, Status = IC to Create IF

If IF# (Inventory Control) is not blank, Status = Logistics to Add Freight Expense

If Logistics Status (Logistics) = Delivered, Status = Delivered

If All Freight Invoices Received (Logistics) = True, Status = AMT to Submit Debit

If AMT Submitted Debit for Transfer (AMT) = True, Status = Closed

S.Stone

@KHiatusInfinite is that the priority order you want? There's a lot of things going on there that might be true at the same time. For example, if your TO# or IF# has any values (so they are "not blank"), then a single status formula won't even look at the rest of the equation for Logistics, Freight Invoices, or AMT submitted. That means a single formula like this could result in "false positives" where it can produce a status, but it may not be the desired status.

• Cancel WT = Yes, Status = Cancelled
• If Demand Planning/AMT Input Complete (AMT) = True, Status = Finance to Add Cost
• If Finance Input Complete (Finance) = True, Status = IC to Set Up TO
• IF TO# (Inventory Control) is not blank, Status = IC to Create IF
• If IF# (Inventory Control) is not blank, Status = Logistics to Add Freight Expense
• If Logistics Status (Logistics) = Delivered, Status = Delivered
• If All Freight Invoices Received (Logistics) = True, Status = AMT to Submit Debit
• If AMT Submitted Debit for Transfer (AMT) = True, Status = Closed

What I might do if I was setting this up is to first setup helper columns to check for these specific status situations. This is helpful for making sure all the different types of statuses populate as expected. You can hide all of these once you're done testing so they don't clutter the sheet. Then you could write a final formula that just grabs the final "status" that you need, and that's when you could settle on that final ranking order.