Nested IF / AND / OR formula help needed
I need to create a formula which drives the RGG ball in the Contact Compliance Status" field based upon RGG values in the previous 6 columns, based upon the following.
Possible Values in the 6 previous columns will be Green, Red, Gray or blank:
I've tried several versions of =IF(AND(OR ... but haven't been successful. Any assistance would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!