Last active
June 5, 2019 19:32
-
-
Save tet3/8bcda70a66ffbe5d7e1dc5bc62b06e53 to your computer and use it in GitHub Desktop.
Semi-revised formula for https://salesforce.stackexchange.com/questions/264936/formula-field-with-several-nested-functions-cant-get-right-syntax
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| IF(TEXT(Next_Refinement_Kit_Action__c) = "AWAIT Refinement PHOTOS","Photo Stage", | |
| IF(OR( | |
| ISPICKVAL(Next_Refinement_Action__c,"PATIENT REQUESTS REFINEMENTS"), | |
| ISPICKVAL(Next_Refinement_Action__c,"SEND REFINEMENT PHOTOS TO ORTHO")),"Photo Stage", | |
| IF(OR( | |
| TEXT(Next_Refinement_Kit_Action__c) = "AWAIT Refinement KIT", | |
| TEXT(Next_Refinement_Kit_Action__c) = "AWAIT Refinement Redo KIT", | |
| TEXT(Next_Refinement_Kit_Action__c) = "GRADE Refinement PVS", | |
| TEXT(Next_Refinement_Kit_Action__c) = "REQUEST Refinement REDO KIT", | |
| TEXT(Next_Refinement_Kit_Action__c) = "SCAN KIT", | |
| TEXT(Next_Refinement_Kit_Action__c) = "SEND STLS TO CC"),"PVS/Scan Stage", | |
| IF(OR( | |
| ISPICKVAL(Next_Refinement_Action__c,"AWAIT REFINEMENT PVS"), | |
| ISPICKVAL(Next_Refinement_Action__c,"SCAN REFINEMENT PVS"), | |
| ISPICKVAL(Next_Refinement_Action__c,"SEND REFINEMENT TO MESH/SCULPT"), | |
| ISPICKVAL(Next_Refinement_Action__c,"AWAIT REFINEMENT MESH/SCULPT"), | |
| ISPICKVAL(Next_Refinement_Action__c,"SEND REFINEMENT STLS TO CC"), | |
| ISPICKVAL(Next_Refinement_Action__c,"REQUEST Refinement REDO KIT"), | |
| ISPICKVAL(Next_Refinement_Action__c,"AWAIT Refinement Redo KIT"), | |
| ISPICKVAL(Next_Refinement_Action__c,"SEND Refinement STLS TO FC")),"PVS/Scan Stage", | |
| IF(TEXT(Next_Refinement_Kit_Action__c) = "AWAIT Refinement TP","TP Stage", | |
| IF(OR( | |
| ISPICKVAL(Next_Refinement_Action__c,"AWAIT REFINEMENT TP"), | |
| ISPICKVAL(Next_Refinement_Action__c,"SEND REFINEMENT TP TO ORTHO"), | |
| ISPICKVAL(Next_Refinement_Action__c,"SEND REFINEMENT TP TO CUSTOMER")),"TP Stage", | |
| IF( | |
| ISPICKVAL(Last_Refinement_Comm__c,"Customer approved TP"),"Production/Active", | |
| IF(OR( | |
| ISPICKVAL(Next_Refinement_Action__c,"MANUFACTURE REFINEMENT ALIGNERS"), | |
| ISPICKVAL(Next_Refinement_Action__c,"REFINEMENT ALIGNERS SENT TO CUSTOMER"), | |
| ISPICKVAL(Next_Refinement_Action__c,"ACTIVE REFINEMENTS CUSTOMER")),"Production/Active", | |
| IF( | |
| TEXT(Next_Refinement_Kit_Action__c,"AWAIT Refinement TP"),"Production/Active" | |
| )))))))) | |
| ,"") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment