function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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 ,
Deepak Maheshwari 7Deepak Maheshwari 7



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)