You need to sign in to do that
Don't have an account?
Vinay Salve
Automate Setups
Hi Team,
Request you to please assist, as I am stuck on the step 7 of process automation, I have tried both methods of completing it, however there is no luck
1. I edited the existing process builder date formula from [Opportunity].CloseDate + 180 to
Option 1.
CASE(MOD([Opportunity].CloseDate + 180 – DATE(1900, 1, 7),7), 0, [Opportunity].CloseDate + 181, 6, [Opportunity].CloseDate + 182, [Opportunity].CloseDate + 180)
Option 1 Syntax Error Message
Your changes are saved, but you can't activate this process until you resolve the following errors. The formula expression is invalid: Syntax error
Option 2
CASE( WEEKDAY([Opportunity].CloseDate),
2, [Opportunity].CloseDate+182,
3, [Opportunity].CloseDate+181,
[Opportunity].CloseDate+180)
Option 2 Challenge Error 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.
I also created a new process builder as follows, however the formula doesn't seems to be correct and is giving error message for both Saturday and Sunday date criteria as follows
Thanks in advance
Vinay Kumar Salve
Request you to please assist, as I am stuck on the step 7 of process automation, I have tried both methods of completing it, however there is no luck
1. I edited the existing process builder date formula from [Opportunity].CloseDate + 180 to
Option 1.
CASE(MOD([Opportunity].CloseDate + 180 – DATE(1900, 1, 7),7), 0, [Opportunity].CloseDate + 181, 6, [Opportunity].CloseDate + 182, [Opportunity].CloseDate + 180)
Option 1 Syntax Error Message
Your changes are saved, but you can't activate this process until you resolve the following errors. The formula expression is invalid: Syntax error
Option 2
CASE( WEEKDAY([Opportunity].CloseDate),
2, [Opportunity].CloseDate+182,
3, [Opportunity].CloseDate+181,
[Opportunity].CloseDate+180)
Option 2 Challenge Error 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.
I also created a new process builder as follows, however the formula doesn't seems to be correct and is giving error message for both Saturday and Sunday date criteria as follows
Thanks in advance
Vinay Kumar Salve
Greetings to you!
Please refer to the below links with a similar discussion which might help you further with the above issue.
https://developer.salesforce.com/forums/?id=9060G0000005d9DQAQ
https://developer.salesforce.com/forums/?id=9060G000000BgW1QAK
https://developer.salesforce.com/forums/?id=9062I000000g3QpQAI
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
Thanks and Regards,
Khan Anas
All Answers
Greetings to you!
Please refer to the below links with a similar discussion which might help you further with the above issue.
https://developer.salesforce.com/forums/?id=9060G0000005d9DQAQ
https://developer.salesforce.com/forums/?id=9060G000000BgW1QAK
https://developer.salesforce.com/forums/?id=9062I000000g3QpQAI
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
Thanks and Regards,
Khan Anas
Thanks for the response, however nothing is working, I am still not able to clear the challenge
I have tried all the permutations and combinations possible, however still I am not able to complete the challenge.
Thanks
Vinay Kumar Salve