I have multiple columns, but the two main columns are called "Clear To Ship" and "Build Date". I want to create another column with the following logic:
If anything in the row is Highlighted, then put "Change"
If Clear to Ship is Not Blank and nothing in the row is Highlighted, then put "Recognized"
If Clear to Ship is Blank and Build Date is Blank, then put "Open Order"
If you could help that would be great.
