Could you help me create an formula for the following

Options

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 any data in the row is Highlighted, then put "Change"

If Clear to Ship is Not Blank and the data in the row is not 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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!