• Mollie D
  • NEWBIE
  • 0 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
From Karina Kaiser @ salesforce:

Because of the limitations on the formula field, this would require creating three fields: “Days Since Closed”, “Days Since Open” and “Age”. Only the “Age” field would be visible on the page layout the others would have to be hidden. 

Formula Fields with Number data type and zero decimal points. Below are the formula values for the fields. 

  1. Days Since Closed  = TODAY() - {!CloseDate}
  2. Days Since Open = NOW() - {!CreatedDate}
  3. Age = IF(ISPICKVAL({!StageName},"Closed Lost"),{!Number_Since_Open__c} -  {!Days_Since_Closed__c},NOW() - {!CreatedDate})
Hopefully this will help you.