Conditional Coulmn

Hi    I've added a new conditional column for ticket status.   It is pulling status from other columns,  So if Complaint is Yes it should display Pending Acknowledgement, then if LOA is Sent it sh...