+ Start a Discussion
Michele Losch 4Michele Losch 4 

Process Automation Specialist Superbadge Step 2

I'm unable to check step 2: Automate Accounts because I'm receiving this error: Challenge Not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: ZKCVFIZH
 
Best Answer chosen by Michele Losch 4
Michele Losch 4Michele Losch 4
I fixed my validation rules and the error went away.

All Answers

Waqar Hussain SFWaqar Hussain SF
Please share the trail head challenge URL.
Michele Losch 4Michele Losch 4
https://trailhead.salesforce.com/super_badges/superbadge_process_automation
Michele Losch 4Michele Losch 4
I fixed my validation rules and the error went away.
This was selected as the best answer
Dan_HuxtedDan_Huxted
Can you confirm the actions you took for step 1 "Automate Leads". My validation rule, two queues for leads, and a lead assignment rule behave as expected, but i'm getting the same error as above. I can only assume i've missed something or named somethign incorrect to get that error as you seem to have got past it ok?
Amit Khanduri.Amit Khanduri.
HI Michele Could you please share the validation rule as am also stuck with same error.
Michele Losch 4Michele Losch 4
@Dan 
The following worked for me: Country validation rule- Not(
OR ( Country = "US", Country ="USA", ISBLANK( Country )))

State- OR( 
LEN(State) <> 2, 
NOT( 
CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & 
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & 
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & 
"WA:WV:WI:WY:PR", State) 
))
Michele Losch 4Michele Losch 4
@Amit
I had to separate all the validation requirements
Billing Country- NOT 
OR ( BillingCountry = "US", BillingCountry ="USA", ISBLANK( BillingCountry ))

Billing State- AND ( 
OR(BillingCountry = "US", BillingCountry="USA", ISBLANK(BillingCountry)), 
OR( 
LEN(BillingState) < 2, 
NOT( 
CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & 
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & 
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & 
"WA:WV:WI:WY", BillingState) 
)))

Customer Channel- AND( 
( ISPICKVAL( Type , "Customer - Channel")), ISCHANGED(Name) )

Customer Direct- AND( 
( ISPICKVAL( Type , "Customer - Direct")), ISCHANGED(Name) )

For shipping use the same for billing just change fields.

Let me know if you are able to get pass this challenge. I'm having an issue with the custom fields
Stevie Burt 7Stevie Burt 7

@Michele - I cannot seem to get passed Challange 1. Im receiving the above error as well. I updated my Validation Rule into 2 different Rules like you had above. 

Country_Validation

NOT(
    OR(
       Country = "US", 
       Country = "USA", 
       ISBLANK( Country )
        )
     )
 

State_Validation

OR( 
   LEN(State) <> 2, 
   NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & 
                "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & 
                "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & 
                "WA:WV:WI:WY:PR", State))
   )
 

I created 2 Leads Queues ("Assembly System Sales" & "Rainbow Sales")
And I created a NEW Lead Assignment Rule Called Trailhead:
User-added image

Im not sure what I am missing to pass this challenge! 

Stevie Burt 7Stevie Burt 7
Nevermind - I got passed it - I had to change the Validation Rules from Top of Page to the specific fields. So "Country" for the Country Validation and "State/Province" for the State! Thank You!!!
wcraigwcraig

Running into issues with the 

"Challenge Not yet complete... here's what's wrong: 
Please check the configuration of the custom fields on the Account object. The formulas, rollup summaries, etc. did not produce the expected outcome."

Call_for_Service__c:  

IF(Last_won_deal_date__c < TODAY()-730,"YES","NO")

Roll up summaries appear to be correct, I also ran this using DATE(YEAR(TODAY()-2,MONTH(TODAY()),DAY(TODAY())) to no avail

Maheshkumar Selvaraj 10Maheshkumar Selvaraj 10
Use the below formula field for 'Call for Service': 
IF(OR(TODAY() - 730 > Last_Won_Deal_Date__c,TODAY() + 730 < Last_Won_Deal_Date__c) ,'Yes','No')
(By Business logic, Deal close date could not be a future date. However, for this challenge, we should include that check as well)
Apoorv Shukla 8Apoorv Shukla 8
Finally Challenge 2 Complete. Thanks @Michele
all my other Validation rules were ok but the "Account Name Change Not Allowed" was prolebmatic, I created both the "Customer - Channel" and "Customer - Direct" in one Validation rule, I splitted them in two rules and Voila.. its completed...!!!!
Michele Losch 4Michele Losch 4
Was anyone able to pass step 5: automate opportunites? I keep getting different errors. 
Stevie Burt 7Stevie Burt 7
@Michele I was able to get past 5 by removing the Account Type filters in my criteria. 
User-added image
Patrick McClellanPatrick McClellan
I'm trying to validate step 2 (all the new Account fields.) I'm getting this error:
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: IHOXZBFU
I am using a new DE org created just for this superbadge. Anybody else seen/gotten past this error? Not sure how to proceed.
 
Patrick McClellanPatrick McClellan
On the Country validations, be sure to include "United States", not use "US" and "USA".
Stevie Burt 7Stevie Burt 7
@Patrick - I actually couldn't pass the Challenge when I included "United States". I had to just use the [NULL], "US" and "USA".
Apoorv Shukla 8Apoorv Shukla 8
@Stevie, yes you are right, I checked in Execute Anonymous debug logs for the test cases that SFDC is running, they are only testing against US and USA not United States.
Patrick McClellanPatrick McClellan
Hi @Stevie. Here's the validation code I used for ShippingCountry -- modified for BillingCountry and for the Leads validation. The instructions say to include it.
NOT (OR(  ShippingCountry   = "US", ShippingCountry="USA", ShippingCountry="United States", ISBLANK(ShippingCountry)))

 
Stevie Burt 7Stevie Burt 7
@Patrick, Yes that is what it says...and I had initially put that in. But like @Apoorv stated, they dont test against it. Once I removed that I was able to clear that challenge. That was yesterday. So maybe they are changing them. If you are having issues, I would do what @Apoorv did and check the Debug Logs to find out exactly where you are getting hung up. 
Tatiana Goss 1Tatiana Goss 1

Like many of you I am stuck as well on the Process Automation Super Badge Step 1.  I've read the thread here and in similar forums.  I've split my Account State / Country validations into 2 separate validation rules.  I've made sure to mark that the error should appear next to the field.  For the country, I'm only including US, USA and null as suggested.  I've copied and pasted the validation rules provided by Michelle.  I did create a brand new "trailhead" playground for the challenge and repeated everything with the same results.  Any other ideas?

Patrick McClellanPatrick McClellan
If you open the Developer Console before you press the validate button, logs of the validation tests will be created--which can be illuminating. (For example, one of the validations they do is to set up an account where state= "NYY".) I assume you've tried manually testing by creating accounts in every possible combination of state/country -- correct state/bad country, bad state/bad country, bad state/good country, etc.

If the error you're getting says your validation isn't correct, then you've got an error somewhere in the logic. However, there are a number of people (myself included) that are getting a more troublesome error elsewhere in the module (Challenge 2 for me). That error looks like this:
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: IHOXZBFU

Note that the error id tag at the end changes each time you try to validate.
Tatiana Goss 1Tatiana Goss 1
Patrick - Thank you for the response, I should have added that I am getting that pesky error with th ever changing reference error id.  I take it you have not moved past this?
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: UELGTFBI
And yes prior to completely re-doing the validation rules to what has been posted on this thread I had tested my original validation rule which was all encompasing and it was working perfectly (via visual test).  However this odd error makes it very unhelpful to figure out what went wrong.  I'm wondering if it is something going on this week.
wcraigwcraig
Awesome, that's SO helpful. Why didn't I think of that!! Sent from iOS
Patrick McClellanPatrick McClellan
I've heard back from Trailhead editors, they're working on the issue today (7/28/17). 
Tony White (BNE)Tony White (BNE)

I am also stuck at challenge 4 (Sales process) with the 

We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: PSCVUDBY

Tony White (BNE)Tony White (BNE)
Ok, got passed this error for Challenge 4, used the debug logs on the developer console to see that I had the stage name wrong, fixed that and it passed!
Hussain GadisaazHussain Gadisaaz
Hello!
Process Automation Specialist Challenge #2
Challenge Not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: PBFVOSOK

getting same error! 
Simon BurrowsSimon Burrows
Stuck on Security Specialist Superbadge, Challenge 5. Same error as everyone else

Challenge Not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: BYPQGDVF

If anyone has any ideas, I'd greatly appreciate it
Marina Shuman 1Marina Shuman 1
For step 2, I had to change the Call for Service results to "Yes" and "No", instead of "YES" or "yes". I guess proper case matters...?
stsramstsram
I have problem understanding the requirement in step 2 which of these right
1)The account name is created  the first time and cannot be edited or updated later (or)
2)the person who created the acccount record can edit but no any other person(or)
3)The acount name is balnk and cannot be updated during creation.
Which one of the above requirement is right?
Paras PrajapatiParas Prajapati
Automate Opportunities Challenge 5 - Not completing....

Challenge Not yet complete... here's what's wrong:
An Opportunity with the Stage 'Negotiation/Review' and the Amount greater than $100,000 was not rejected successfully by your manager or the Opportunity Stage was not updated to 'Negotiation/Review'.

Not able to understand why this issue is coming, now when I am creating Opportunity and I am able see it going for approval and able to do Approval / Rejection, but when I am checking Challenge in Superbadge the above issue is coming, not able to track what is the issue.
Febrian Tarigan 7Febrian Tarigan 7
I keep getting this error for automate opportunities challenge 5

A new Opportunity with a 'Prospecting' stage for a 'Prospect' Account did not successfully create a Task for the Account owner with the Subject 'Send Marketing Materials'.

don't understand what the problem here. i have test the process builder and it works. can anyone help me with this error?
Alap MistryAlap Mistry
Hello Paras Prajapati and Febrian Tarigan,
 
Regards,
Alap Mistry
Abhinav PaulAbhinav Paul
Hello,

I am getting the error-
An Opportunity with the Stage 'Negotiation/Review' and the Amount greater than $100,000 was not rejected successfully by your manager or the Opportunity Stage was not updated to 'Negotiation/Review'.

I tried with all possible solutions (removing account type from process builder, changes in approval process etc) but didnt work.
When I run dry test, its working fine.

Can anyone help to resolve this error. ?
Shubham Agarwal 56Shubham Agarwal 56
Hello,

I'm unable to check step 2: Automate Accounts:     
              Because I'm receiving this error:  Challenge Not yet complete... here's what's wrong: 
              Please check the custom fields on the Account object. Not all custom fields were found.


 
Praneetha MurakondaPraneetha Murakonda

Hello All,

I'm unable to check the step 2: Automate Accounts because i'm receiving the following error:

Challenge Not yet complete... here's what's wrong: 
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Please enter valid shipping country: []

while creating Account and Opportunity i'm not receiving error in the org. Please suggest if there is any workaround.

Thanks!

Bareera NoorBareera Noor
I am working on the Challenge 2: I am getting the following error
Challenge Not yet complete... here's what's wrong: 
Please check the configuration of the custom fields on the Account object. The formulas, rollup summaries, etc. did not produce the expected outcome.
I created 2 formula fields. Call for Service
                                          Amount of Won Deals
                                          Deal Win Pecent
Call for Service and Amount of Won Deals are working fine. But I am not sure for the  Deal Win Pecent
Please Help me out with this one.
Suvarna DeshSuvarna Desh
Anyone recently completed Challenge 2?? I tried every solution mentioned above. created rollup summary fields, formula fields from scratch twice, created all validation rules separately. tried every option mentioned above for "call for service". the error doesn't go away. It says "Challenge Not yet complete... here's what's wrong: 
Please check the configuration of the custom fields on the Account object. The formulas, rollup summaries, etc. did not produce the expected outcome." I tried every option that I can think of. Really need help here.  
Suvarna DeshSuvarna Desh
contd...Is there any way to debug these custom fields (module 2:automate accounts)
Ed DumasEd Dumas
https://developer.salesforce.com/forums/ForumsMain?id=9060G000000BgNxQAK - see Nathan Bruhn's comment.  Worked for me.
Pablo CabornoPablo Caborno
Guys, I passed this challenge after days of working this thing around again and again. The problem for me was the 
'Number of deals' and 'Number of won deals' fields, for these rollup summary fields you don´t have to apply the SUM operation, just select COUNT. I applied it to the Quantity field, that was wrong.
Syam Reddy 11Syam Reddy 11
User-added image

Hello All,

Facing a Null point exception, can some let me know what need to do here.

Thanks,
SyamReddy.
Eswar Varma MudunuriEswar Varma Mudunuri
Challenge Not yet complete... here's what's wrong: 
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, 'Hey McFly, unless you are planning to go back in time, please update your close date': []

2.Automate Accounts
Create validation rules and account formula fields as specified in the business requirements. Use the following field names.

For this metric or field, Use this Field Name
Number of deals, Number_of_deals__c
Number of won deals, Number_of_won_deals__c
Last won deal date, Last_won_deal_date__c
Deal win percent, Deal_win_percent__c
Amount of won deals, Amount_of_Won_Deals__c
Call for Service, Call_for_Service__c
DANIEL CADWELLL 11DANIEL CADWELLL 11
I have been working on this for 8 hours straight and have gone through all of the above and nothing works I am still getting the error:
Challenge Not yet complete... here's what's wrong: 
Please check the configuration of the custom fields on the Account object. The formulas,
roll-up summaries, etc. did not produce the expected outcome.
Which is pretty vague. But I have gone through and tripled checked my API and Label names see below screenshot:
User-added image
User-added image
User-added image
User-added image
User-added image
It won't let me upload the 6th image but it is Number of won deals Roll-up summary with count on opportunities. Filter critera = stage = closed won. API = Number_of_won_deals__c.

I would appreciate any help on this to get over this challange.
 
Kalin BobchevKalin Bobchev

Hi Daniel,
Have you passed?
I have the same configuration like yours and can not pass.
I even tryed to change names thinking if they have mistake:
Amount of won deals, Amount_of_Won_Deals__c - only here API name is different

 

Brian Miller 56Brian Miller 56
A possibly easier way to get the Formula portion for State, as opposed to LEN.  I used NOT (REGEX(State, "[A-Z]{2}")).  It was good enough to Pass, but not as precise as spelling out all State postal abbrevs.  
Abderrahmane TRIAAbderrahmane TRIA
Hi all
two days after i have this error :
Challenge Not yet complete... here's what's wrong: 
Please check the configuration of the custom fields on the Account object. The formulas,roll-up summaries, etc. did not produce the expected outcome.

-Field 1:
Label: Number of deals
API Name: Number_of_deals__c 
Data Type: Roll-Up Summary
Summary Type: COUNT
Summarized Object: Opportunity
Filter Criteria: None
-Field 2:
Label: Number of won deals 
API Name: Number_of_won_deals__c 
Data Type: Roll-Up Summary
Summary Type: COUNT
Summarized Object: Opportunity
Filter Criteria: Stage EQUALS Closed Won
-Field 3:
Label: Last won deal date 
API Name: Last_won_deal_date__c 
Data Type: Roll-Up Summary
Summary Type: MAX
Field to Aggregate: Opportunity: Close Date
Summarized Object: Opportunity
Filter Criteria: Stage EQUALS Closed Won
-Field 4:
Label: Deal win percent 
API Name: Deal_win_percent__c 
Data Type: Formula
Return Type: Percent
Decimal Places: 0
Formula: Number_of_won_deals__c / Number_of_deals__c
-Field 5:
Label: Amount of won deals
API Name: Amount_of_won_deals__c 
Data Type: Roll-Up Summary
Summary Type: SUM
Field to Aggregate: Opportunity: Amount
Summarized Object: Opportunity
Filter Criteria: Stage EQUALS Closed Won
-Field 6:
Label: Call for Service
API Name: Call_for_Service__c 
Data Type: Formula
Return Type: Text
Formula: IF( DATE( YEAR(Last_won_deal_date__c)+2 , MONTH(Last_won_deal_date__c) , DAY(Last_won_deal_date__c) ) <= TODAY(), 'Yes', 'No')
 
Orjan J HolvikOrjan J Holvik
Hi All!

I've been stuck on step two for some time now. 
I get the following error message

"
Challenge Not yet complete... here's what's wrong:
Please check the custom fields on the Account object. Not all custom fields were found.
"

I don't understand this error as all the custom fields have been created, labelled as insctructed and they are all working 
Number of deals, Number_of_deals__c
Number of won deals, Number_of_won_deals__c
Last won deal date, Last_won_deal_date__c
Deal win percent, Deal_win_percent__c
Amount of won deals, Amount_of_Won_Deals__c
Call for Service, Call_for_Service__c


Any input is highly appreciated
Amit AwasthiAmit Awasthi
Hi All
Challenge Not yet complete... here's what's wrong:
Error: Please check the custom fields on the Account object. Not all custom fields were found.

Superbadgeshttps://trailhead.salesforce.com/super_badges/superbadge_process_automation- Automate Accounts
Create validation rules and account formula fields as specified in the business requirements. Use the following field names.

For this metric or field, Use this Field Name
Number of deals, Number_of_deals__c
Number of won deals, Number_of_won_deals__c
Last won deal date, Last_won_deal_date__c
Deal win percent, Deal_win_percent__c
Amount of won deals, Amount_of_Won_Deals__c
Call for Service, Call_for_Service__c
 
Venkata GorantlaVenkata Gorantla
@Abderrahmane TRIA, I had exactly same setup as yours and the only diiference is the field 2. And I passed the challenge.

Please use the below configuration for the field 2:
Label: Number of won deals 
API Name: Number_of_won_deals__c 
Data Type: Roll-Up Summary
Summary Type: COUNT
Summarized Object: Opportunity
Filter Criteria:
Won EQUALS True

 
Venkata GorantlaVenkata Gorantla
Hi Amit Awasthi,

Please use the below configuration:

-Field 1:
Label: Number of deals
API Name: Number_of_deals__c 
Data Type: Roll-Up Summary
Summary Type: COUNT
Summarized Object: Opportunity
Filter Criteria: None


-Field 2:
Label: Number of won deals 
API Name: Number_of_won_deals__c 
Data Type: Roll-Up Summary
Summary Type: COUNT
Summarized Object: Opportunity
Filter Criteria: Won EQUALS True


-Field 3:
Label: Last won deal date 
API Name: Last_won_deal_date__c 
Data Type: Roll-Up Summary
Summary Type: MAX
Field to Aggregate: Opportunity: Close Date
Summarized Object: Opportunity
Filter Criteria: Stage EQUALS Closed Won


-Field 4:
Label: Deal win percent 
API Name: Deal_win_percent__c 
Data Type: Formula
Return Type: Percent
Decimal Places: 0
Formula: Number_of_won_deals__c / Number_of_deals__c


-Field 5:
Label: Amount of won deals
API Name: Amount_of_won_deals__c 
Data Type: Roll-Up Summary
Summary Type: SUM
Field to Aggregate: Opportunity: Amount
Summarized Object: Opportunity
Filter Criteria: Stage EQUALS Closed Won


-Field 6:
Label: Call for Service
API Name: Call_for_Service__c 
Data Type: Formula
Return Type: Text
Formula: IF( DATE( YEAR(Last_won_deal_date__c)+2 , MONTH(Last_won_deal_date__c) , DAY(Last_won_deal_date__c) ) <= TODAY(), 'Yes', 'No')

Let me know if you any issues.
Amit AwasthiAmit Awasthi
Thanks
@Venkata Gorantla
Amit AwasthiAmit Awasthi
Now i m facing this errorI m also create this formula field
Venkata GorantlaVenkata Gorantla
@Amit,

Please use this formula:
 
CASE( MOD( DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")

 
Amit AwasthiAmit Awasthi
I also used this formula but didn't found this formula field.
Venkata GorantlaVenkata Gorantla
Okay. Make sure you are checking the solution on the same trailhead as you made changes
Colince FOTSO 15Colince FOTSO 15
Hello,

I have the same issue like @Syam Reddy 11, in Process Automation Specialist Superbadge Step 2. After craeting new custom fields on Account and validation rules.
User-added image

Please, someone can help me?

Thank in advance
Devender Baghel 8Devender Baghel 8
Hello,

There could be many reasons and for each issue , debug logs can really help to dig out the root cause.
I was able to fiund in my case through logs and fixed the issue with below validations for shipping country.

Error: A validation rule did not prevent a new Account from being saved when Shipping Country is blank and Shipping State has three characters.

Solution: NOT(OR(ShippingCountry= 'USA', ShippingCountry= 'United States', ShippingCountry= 'US', ShippingCountry= null)) || LEN(ShippingState) <> 2

same for BillingCountry as well.

Thanks
Dax
SUNETRA DEYSUNETRA DEY
@Devender,I am facing this same problem but your solution is not resolving my issue. 
VIJAY_MVIJAY_M
@Devender, Even I am not able to sort out the issue using your solution.
MPB SalesforceMPB Salesforce
Hi all if you have any query in this challenge 2 so please watch this video at least once i hope you will get your solution
https://www.youtube.com/watch?v=e-exf-MUWzU&list=PLQf_Kv-dMRBJNdXFH44hPImsHY47yaG12&index=5
SUNETRA DEYSUNETRA DEY
@MBP Salesforce thank you for the video, but it is not resolving the issue -
*
Challenge Not yet complete... here's what's wrong:
A validation rule did not prevent a new Account from being saved when Shipping Country is blank and Shipping State has three characters.
*
Please help to resolve this issue.
MPB SalesforceMPB Salesforce

@SUNTRA
Can you Share your validation rule screen short
its looked out
 

Billing_Country_Validation_Rule
NOT(OR(BillingCountry = "US", BillingCountry = "USA", BillingCountry = "United States", ISBLANK(BillingCountry)))

Billing_State_Validation_Rules
OR(
LEN(BillingState) <> 2,
NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
"WA:WV:WI:WY:PR", BillingState))
)

For_Customer_Channel
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Channel')

For_Customer_Direct
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Direct' )

Shipping_Country_Validation_Rule
NOT(OR(ShippingCountry = "US", ShippingCountry = "USA", ShippingCountry = "United States", ISBLANK(ShippingCountry)))

Shipping_State_Validation_Rule
OR(
LEN(ShippingState) <> 2,
NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
"WA:WV:WI:WY:PR", ShippingState))
)










bye hlep of this I have completed my super badage

User-added image

MPB SalesforceMPB Salesforce
User-added imageUser-added imageUser-added imageUser-added imageUser-added image
MPB SalesforceMPB Salesforce
User-added image
SUNETRA DEYSUNETRA DEY
I inactivated the triggers in Account and my issue is resolved. Thank you @MPB Salesforce for your help. :)
Sagar SawalSagar Sawal
@Venkata Gorantla I followed the same as you mention still facing same issue 
ColbridgeColbridge
I tried to combine all the validation into one and it didn't work. But was ok when I seperated it as @Michele mentioned, thanks. 
abhishek kumar 775abhishek kumar 775
Hi , I am getting below in Process Automation Specialist Superbadge Challemge 2:

Challenge Not yet complete... here's what's wrong:
Please check the custom fields on the Account object. Not all custom fields were found.

Please check and help me out.

User-added imageUser-added imageUser-added imageUser-added image
Ravindra AdithiyanRavindra Adithiyan
@abhishek kumar 775, @Colbridge,

Try deactivating the trigger in the org and try the below steps:
1.Create Validation Rules:
 OR(
AND(
LEN(BillingState) > 2,
NOT(CONTAINS('AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:WA:WV:WI:WY', BillingState ))
),
AND(
LEN(ShippingState) > 2, NOT(CONTAINS('AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:WA:WV:WI:WY', ShippingState))
),
NOT(OR(BillingCountry ='US',BillingCountry ='USA',BillingCountry ='United States', ISBLANK(BillingCountry))), NOT(OR(ShippingCountry ='US',ShippingCountry ='USA',ShippingCountry ='United States',ISBLANK(ShippingCountry)))
,
AND(( ISPICKVAL( Type , "Customer - Channel")),ISCHANGED(Name)),
AND(( ISPICKVAL( Type , "Customer - Direct")), ISCHANGED(Name))
)

The above formula fulfills the State/Country validation and the Customer Type Validation.

2.Create the following Custom fields
     i.Number_of_deals__c
       type – rollupSummary
       count of all opportunities
     ii.Number_of_won_deals__c
        type – rollupSummary
        count the opportunities which are having the stage equals closed-won
     iii.Last_won_deal_date__c
         type – rollupSummary
         Max of opportunities closeddate which are having the stage equals closed-won
     iv.Deal_win_percent__c
         type -Formula (Percent)
         Number_of_won_deals__c / Number_of_deals__c
      v.Amount_of_Won_Deals__c
         type – rollupSummary
         the sum of all opportunities amount which is having the stage equals closed-won
      vi.Call_for_Service__c
          type -Formula (text)
          IF(DATE(YEAR(Last_won_deal_date__c)+2,MONTH(Last_won_deal_date__c),DAY(Last_won_deal_date__c))<= TODAY(),"Yes","No")

Note: (Last_won_deal_date__c)+2 inculded in the formula because the year can be leap/normal so doing total number number of days will not help.

Hope the above steps will help to clear the challenge 2.


Cheers,
RJ
 
Silvian ConstantinSilvian Constantin
I don't understand why you'd want to validate text fields for country and state when you could simply convert these to Picklist and only use Country = US and associated States. See State and Country/Territory Picklists under Data section in Settings.
I find this to be a much more elegant solution: selecting a value from a picklist requires a lot less time than manual text input.
I understand that the source might be a problem (if it's coming from Web - the web form should be customizable or if it's coming from a list - then that's aeasy mapping exercise before import). 
Any thoughts?
Spurthi Pasham 7Spurthi Pasham 7
Exactly my point @Silvian. Anyone know why they’re having us create a Validation Rule for State, especially when it’s more seamless to create picklist value and make it "required" since the values are finite. 
hel tophel top
Cash on Card is one of the best cash from credit card services. We help customers to solve their financial problems by providing spot cash against credit cards. Get to know more about Cash on Credit Card here. https://cashoncreditcardss.in