You need to sign in to do that
Don't have an account?
Arbi Llaveshi
Error: Formula result is data type (Number), incompatible with expected data type (Text).
IF(ISPICKVAL(StageName, "CLOSED_WON:_INACTIVE") , DATEVALUE(LastModifiedDate) - CloseDate, null)
To fix this you have to either change the "Formula Return Type" to Number or change the formula to
IF(ISPICKVAL(StageName, "CLOSED_WON:_INACTIVE") , TEXT(DATEVALUE(LastModifiedDate) - CloseDate) , null)
All Answers
To fix this you have to either change the "Formula Return Type" to Number or change the formula to
IF(ISPICKVAL(StageName, "CLOSED_WON:_INACTIVE") , TEXT(DATEVALUE(LastModifiedDate) - CloseDate) , null)
IF(ISPICKVAL(StageName, "CLOSED_WON:_INACTIVE") , Text(DATEVALUE(LastModifiedDate) - CloseDate), null)