I've competed all steps in challenge 2 on the Process Automation Specialist Superbadge, but when I check it, an error comes back saying

"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, Both Billing Country and Shipping Country must be populated. Can be US, USA, or United States: []"

Here is the rule I set up. I tested it and it works. Any idea what is going wrong?

 

Hey guys,

This formula:

IF(AND(ISBLANK( Prospect_First_Name__c ),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide your prospect with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(AND(NOT(ISBLANK( Prospect_First_Name__c )),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide " + Prospect_Full_Name__c + " with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(OR(ISPICKVAL((StageName,'Open')),(ISPICKVAL(StageName,'OSG New'))),"I wanted to follow-up from our discussion to make sure I had addressed all your questions regarding available OSG solutions. Are there any concerns I can address? What are the next steps? I look forward to hearing from you,","")))   

is returning a Missing Parentheses error, and I'm not sure why, it seems like everything lines up. Thanks for the help!!

I cannot receive test emails for templates when I hit send they don't arrive

I've competed all steps in challenge 2 on the Process Automation Specialist Superbadge, but when I check it, an error comes back saying

"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, Both Billing Country and Shipping Country must be populated. Can be US, USA, or United States: []"

Here is the rule I set up. I tested it and it works. Any idea what is going wrong?

 

I am getting this error after trying for 4 days and I cant seem to find the correct setting. Can anyone help me with this?
"Challenge Not yet complete... here's what's wrong:
The Field Sales User profile does not have the correct permissions for managing List Views, creating and managing reports, or creating and managing report folders."

We have a customized field added to opportunity about contract signing date, we want the field is auto filled by the date when the stage of the opportunities changed to "Won- Agreement Signed". as the stage is a picklist field, I cannot use If, but I also failed when I use Case.
This is my formula, it doesn't work. SF said it cannot be used for picklist field.
CASE((StageName  = "Won - AGREEMENT SIGNED & ACCEPTED"),TODAY())
can anyone help me to give a correct script?

thanks very much
Carol

I am using EML and looking to switch to Outlook file format which offers some advanced features to me with conversion. Kindly suggest a good tool to switch from EML to Outlook files with batch conversion facility.

Which programme is Maintains data integrity of PST file and Saving after splitting PST file ?

I currently have a formula field that shows the Upcoming Interview Date, which evaluates our six Client Interview Date fields on the object and displays the next upcoming interview date. 

I am in need of a similar formula field that will display any date scheduled for the previous week (rolling basis). FYI, our "week" begins on Monday for our org. Any ideas?

Thanks in advance!

I have total minutes calculated (total_minutes__c),
How to convert these minutes in Days, Hours and Minutes.
I want something like this :
eg.
Input: total_minutes__c = 12495
Output = 8 Days 16 Hours 15 Minutes 

Thanks in advance.

Hey guys,

This formula:

IF(AND(ISBLANK( Prospect_First_Name__c ),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide your prospect with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(AND(NOT(ISBLANK( Prospect_First_Name__c )),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide " + Prospect_Full_Name__c + " with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(OR(ISPICKVAL((StageName,'Open')),(ISPICKVAL(StageName,'OSG New'))),"I wanted to follow-up from our discussion to make sure I had addressed all your questions regarding available OSG solutions. Are there any concerns I can address? What are the next steps? I look forward to hearing from you,","")))   

is returning a Missing Parentheses error, and I'm not sure why, it seems like everything lines up. Thanks for the help!!

I have a created a custom object. I want the user to type the Salutation, FirstName, and LastName and after saving, it shows up the entire name in one Name field as it happens in Standard Contact Object. I have created a formula field to merge FirstName and LastName into a "Name" field and it's displaying me the full name in one Name field. My main concern that it should work like the same way it work in contact object like before saving we get an option to type Salutation, FirstName, and LastName but after saving, it shows me only one field. I want my entire name should show up at the top of the record page not only my first name. I also tried compact layout to show up my entire name at the top but it didn't work as I am working in Salesforce Classic. Please let me know how to do it. Thank you so much.