Hi all, I am so close to finishing this process automation badge but am stuck in one area in Step 7.

I've built out my process builder as follows





And my date formula as follows
 

Case(MOD(Date__c-DATE(1900,1,7),7),0,"Sunday",1,"Monday",2,"Tuesday",3,"Wednesday",4,"Thursday",5, "Friday",6,"Saturday", "")

 

Challenge Not yet complete... here's what's wrong:  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. 

It works nicely but doesn't seem to pass, what could be up.
 

Hi all, I am so close to finishing this process automation badge but am stuck in one area in Step 7.

I've built out my process builder as follows





And my date formula as follows
 

Case(MOD(Date__c-DATE(1900,1,7),7),0,"Sunday",1,"Monday",2,"Tuesday",3,"Wednesday",4,"Thursday",5, "Friday",6,"Saturday", "")

 

Challenge Not yet complete... here's what's wrong:  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. 

It works nicely but doesn't seem to pass, what could be up.
 

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')

Hello,

I am receiving and Internal Server Error when accessing the external data for invoices. 


My project is created correctly. When I change the Status of the Project to Billable, the invoices related list appears and the status is changed to Billed. The invoices related list only shows the same error text as above.



I found a knowledge article that indicates that this may be a external server issue.

https://help.salesforce.com/articleView?amp;language=en_US&id=000228082&type=1

I have been working on this error for sa couple of days now and do not have any idea how to proceed. Any suggestions would be greatly appreciated.

Thank you

Hello,

I am receiving and Internal Server Error when accessing the external data for invoices. 


My project is created correctly. When I change the Status of the Project to Billable, the invoices related list appears and the status is changed to Billed. The invoices related list only shows the same error text as above.



I found a knowledge article that indicates that this may be a external server issue.

https://help.salesforce.com/articleView?amp;language=en_US&id=000228082&type=1

I have been working on this error for sa couple of days now and do not have any idea how to proceed. Any suggestions would be greatly appreciated.

Thank you