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
Board salesforceBoard salesforce 

calculate days based on Picklist values

Hi All,

I have a picklist field open ,In Progress,Closed . Now i want the days to calculate in Open and In progress values for more than 3 days from created and modfied date  ?

can any one help me out

Thanks ,
Ram
Deepak Maheshwari 7Deepak Maheshwari 7

Hi,

 

Create a formula field with number as a return type and write logic as below:

 

if((today-modified date)+1> 3 && (ispickval(status,"open")||ispickval(status,"in progress")),(today-modified date)+1,null)