AnsweredAssumed Answered

validation rule challenges - won't recognize completion or holds up other flows

Question asked by goodplans4us on Dec 22, 2017
Latest reply on Feb 12, 2018 by goodplans4us

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

 

 

Outcomes