• Hugo Lemos
  • NEWBIE
  • 25 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
I keep getting the following error message, even after trying in 3 new playgrounds: 
Challenge Not yet complete... here's what's wrong: 
Some billing state names do not meet data quality standards, or the data import was unsuccessful.

I followed all of the instructions:
1. Installed unmanaged package in the new playground
2. Added Residential picklist type to Accounts
3. Cleaned up Account list:
a. Removed "Household" from Account name (this wasn't specified, but it didn't seem necessary)
b. Removed duplicate records
c. Changed accounts in ALL CAPS to only cap first letter of first and last name
d. Changed state name to 3 letter State code
e. Saved as .CSV file
4. Imported list using Import Wizard

I received an email confirming the import was successful with 11 rows processed and I see the accounts when I search up accounts in the playground. 

Thanks in advance for any help!
Hi,

I'm not able to complete #2 Automate Accounts. It give me 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."


Can anyone tell me what went wrong? Thanks.

My Custom Fields configuration are as following:
  • Number of deals (Roll-Up Summary field): Count Opportunity. No filter criteria
  • Number of won deals (Roll-Up Summary field): Count Opportunity with filter criteria as "Stage equals Closed Won"
  • Last won deal date (Roll-Up Summary field): MAX(Opportunity: Close Date) with filter criteria as "Stage equals Closed Won"
  • Deal win % (Formula field): Number_of_won_deals__c / Number_of_deals__c
  • Total amount of won deals (Roll-Up Summary field): SUM(Opportunity: Amount) with filter criteria as "Stage equals Closed Won"
  • Call for Service (Formula field): IF( DATE( YEAR(Last_won_deal_date__c)+2 , MONTH(Last_won_deal_date__c) , DAY(Last_won_deal_date__c) ) <= TODAY(), 'YES', 'NO')