+ Start a Discussion
tina sharma 10tina sharma 10 

Trailhead challenge on advanced formula field

I am new to salesforce.

I am trying to complete the trailhead challenge 

https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/implementing_advanced_formulas?trail_id=force_com_admin_advanced

can any one please let me know how to achieve this?

Thanks
Tina
Best Answer chosen by tina sharma 10
Deepali KulshresthaDeepali Kulshrestha
Hi tina,
Please follow the given below Links and steps, with the help of which you can solve your problem, it may be helpful to you :-

1) https://developer.salesforce.com/forums/?id=906F0000000MJIqIAO
2)https://developer.salesforce.com/forums/?id=906F0000000D8IDIA0

Percentage Completed field:
(DATEVALUE( CreatedDate ) - CloseDate ) / 100

Opportunity progress :
IF( Percent_Completed__c < 25 , "Early", 
IF(Percent_Completed__c >25 && Percent_Completed__c <75 ,"Middle","Late"))

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha