+ Start a Discussion
Darrin RobertsDarrin Roberts 

Process Automation Specialist Super Badge Step 7 Issue

I am stuck on Step 7 and appears that many people have had the same issue. My playground is executing everything as requested in the instructions. To meet the criteria in Step 7, I simply created a new process with two diamonds that would add 2 days if the Day of the Week field was Saturday and 1 day if the Day of the Week field was Sunday. 

I created seven opptys with seven different close dates, to run a test representing a close date of every day of the week. There was not Saturday or Sunday in the Day of the Week field, on any of the Robot Set Up records. I got the dreaded "The Robot Setup Day of the Week formula does not seem to be working properly. The Day of the Week should not fall on Saturday or Sunday."

I then went to see what others might be facing. I have tried all the different formulas, change the Day of the Week field to a formula field that represented the days of the week "0-6" and applied the formula to make sure a Saturday and Sunday wouldn't show up and ran the same seven oppty test which met the expected results and still same message "The Robot Setup Day of the Week formula does not seem to be working properly. The Day of the Week should not fall on Saturday or Sunday."

This is the second Super Badge that I am unable to complete, even after achieving the expected results that was put forth in the challenge. 

Is there someone else that had the same issue and was able to resolve this?

Thank you in advance for any assistance.
Narender Singh(Nads)Narender Singh(Nads)
Hi Darrin,
Please make sure your Day of the week field is setup similar to the screenshot I Attached.
Once you do that create a new process. Refer the screenshots(I have only attached screenshots for Saturday, do the same for sunday).

1. Field Configuration snap:
User-added image

2. Process-1:
User-added image

User-added image

Let me know if it helps.
Lineesh L PLineesh L P
The formula for day of the week was really helpful.

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


if you get solution so please select best answer
Merita Osmani 7Merita Osmani 7
Hi all,

I have been facing this issue so many times, and it took me a while to solve it. 

This is how I solved it:

The formula for the field "Day of the Week" should look like this:
CASE( MOD( Date__c - DATE(1900, 1, 7), 7), 0, 'Sunday', 1, 'Monday', 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")

In the already existing Process that you have created previously, go to the node where you have defined the Closed Won Opportunity > Go to the Action where you create the Robot Setup Record and change the "Criteria for Executing Actions" to "No Criteria - just execute".

Make sure your formula is changed to this in the "Set field values" box for the Robot Setup Record Creation Action:
MOD( [Opportunity].CloseDate +180- DATE( 1900, 1, 7 ), 7 ), 
0,  [Opportunity].CloseDate +181, 
6,  [Opportunity].CloseDate +182, 
[Opportunity].CloseDate +180