You need to sign in to do that
Don't have an account?
Ajay Kumar 583
Need To create a Formula On Opportunity.
Hi Team,
Need a formula on Opportunity to show number of days since Opportunity is opened.
For Ex: If Opportunity is created on 1st July, formula field will show “10 days” as of 10th July.
Use Created Date field. Do not show any date if Opportunity is “Closed Won” or “Closed Lost”.
In that case it would show “-1 day”.
Need a formula on Opportunity to show number of days since Opportunity is opened.
For Ex: If Opportunity is created on 1st July, formula field will show “10 days” as of 10th July.
Use Created Date field. Do not show any date if Opportunity is “Closed Won” or “Closed Lost”.
In that case it would show “-1 day”.
Create a formula field with number type and use below formula:-
IF( ISPICKVAL(StageName, "Closed Won") || ISPICKVAL(StageName, "Closed Lost") , -1, TODAY() - DATEVALUE(CreatedDate) )
It will return no. of days counted from created date.
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi