function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
GV1GV1 

formula

Please help !

 

Formula field = Number  of days elapsed between, when the record is in the New status until it is moved into the Open, In prrogress, or Closed statuses

 

Where Status is a picklist field on the same object with the values

  • New
  • Open
  • IN Progress
  • Closed

 

Thanks in advance

Best Answer chosen by Admin (Salesforce Developers) 
Avidev9Avidev9

Seems lik it wont be straight forward solution.

So

  • Create a Date Field to Store the Date of the record when it moves to New. Incase it is same as created date you dont need this
  • Use a worklow to populate this field
  • Similarly Create another field to Store the data when the record was in other statuses and populate the same using WF
  • Use formula field to calculate the Num of days

All Answers

Avidev9Avidev9

Seems lik it wont be straight forward solution.

So

  • Create a Date Field to Store the Date of the record when it moves to New. Incase it is same as created date you dont need this
  • Use a worklow to populate this field
  • Similarly Create another field to Store the data when the record was in other statuses and populate the same using WF
  • Use formula field to calculate the Num of days
This was selected as the best answer
GV1GV1

I had guessed the same, but I have lot more formulas to write for number of days.

I will have to create the ChangeData for each picklist value.

I wish there could be a formula expression for "Date of change".