I need help writing a formula for:
When the field Assembly Hours is left blank, the Status of Change Order (which is a drop-down text field) goes to Awaiting Manufacturing
When the field Material Hours is left blank, the Status of Change Order (which is a drop-down text field) goes to Awaiting Materials
Thank you