You need to sign in to do that
Don't have an account?
jclawson
If Formula for Total Days Open or Total Days Still Open Formula
I have this but keep getting errors. Any ideas on how to make this formula work?
IF(
(NOT(ISPICKVAL( ThinkLP__Status__c ,"Closed","Cancelled",
Today()-datevalue(CreatedDate),
date(Case_Closed_Date__c)-datevalue(CreatedDate))))
IF(
(NOT(ISPICKVAL( ThinkLP__Status__c ,"Closed","Cancelled",
Today()-datevalue(CreatedDate),
date(Case_Closed_Date__c)-datevalue(CreatedDate))))
Try the following Formula , it's work in my Org: I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi
All Answers
Try the following Formula , it's work in my Org: I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi