• Barbara Nila
  • NEWBIE
  • 10 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
Hello,
Why is TODAY() - DATEVALUE(CreatedDate) throwing an error? It keeps telling me "Field CreatedDate may not be used in this type of formula" but I know this is how I need to start out my formula.  What am I doing wrong?
Hello,
Why is TODAY() - DATEVALUE(CreatedDate) throwing an error? It keeps telling me "Field CreatedDate may not be used in this type of formula" but I know this is how I need to start out my formula.  What am I doing wrong?
Hello All,
I have completed this challenge.

1-For this first you need to create a helper formula field(type-percent) 
Percent Completed :
(DATEVALUE( CreatedDate ) - CloseDate )/100


2- Then you need to create the actual formula field (type- text) by using the helper formula field.
Opportunity Progress :

IF( Percent_Completed__c <=25,"Early", 
IF(Percent_Completed__c <=75,"Middle", 
"Late"))

Thanks,
Nida