Hello!
With all my formula questions it was advised to me to try to break them down and test each part and as they are successful put them together. However, I can't get each part of this formula to work. I have a hidden field - Existing Material Job Number - that appears when the question update to existing job is answered as yes. I want that field to also be required if it is answered as yes. However, I can't find a formula that works appropriately. I've tried all the below and then some. Please help. I started with the Update to Existing Job being a check box and didn't get anywhere so I changed it a radio button and still haven't had any luck. 
UpdatetoExistingMaterial=='Yes' doesn’t recognize that it is required
UpdatetoExistingMaterial!='Yes' recognizes that it is required but doesn’t recognize that it is completed
UpdatetoExistingMaterial!='No' recognizes that it is required when yes is chosen but doesn’t recognize that it is completed
UpdatetoExistingMaterial=='No' doesn’t recognize that it is required
ExistingMaterialJobNumber=='' recognizes that is required and releases when completed but it isn’t required all of the time so it needs another condition.
ExistingMaterialJobNumber!='' doesn’t recognize it as required.
UpdatetoExistingMaterial!='Yes'&&ExistingMaterialJobNumber==’’ recognizes that it is required and releases when it is completed but holds up other submissions where this field is hidden or no
UpdatetoExistingMaterial=='Yes'&&ExistingMaterialJobNumber==’’ doesn’t recognize that is required
UpdatetoExistingMaterial!='No'&&ExistingMaterialJobNumber=='' recognizes that it is required when yes is chosen and recognizes that it is completed but holds up other question when the field is hidden/answer is to update is no
UpdatetoExistingMaterial!='No'&&ExistingMaterialJobNumber!='' doesn’t recognize that is required
