IF formula not pulling correct data

[carterfleming]

I have a long-ish IF formula that first needs to only select "Completed" records from the Status column. However, my output file keeps including "Completed/Unapproved" as well. I've tried including [Status] != "Completed/Unapproved" and it keeps pulling it in. Any tips for resolution?

[DataNath · Accepted solution]

@carterfleming if you want to remove records then you can't do that in a Formula tool. You'll have to use a Filter tool with the expression:

[Status] = 'Completed'

The records you want will come out of the top (True) anchor. Once you have only the records you want (based on status), then you can apply your formula to change the fields as necessary.