IF(NOT( IsConverted ), ROUND(NOW()-CreatedDate, 0), NULL)
BUT - realized our managers want to reassign leads after 60 days, how do I construct my formula to recalculate if the owner is changed?
답변 11개
I was thinking about this a little more and realized that if a record is assigned to another user, then reassigned to the original user it would show the difference based on the created date. So if that scenario could come up, I would use this formula. IF(
AND(
IsConverted = False,
NOT(ISBLANK(Owner_Change__c))
),
ROUND(NOW() - Owner_Change__c,0),
ROUND(NOW()-CreatedDate, 0)
)
That way if the owner has been changed and therefore filled in the date field from the workflow. It will always calculate off that date.
Just thought I'd add that in, just in case.
--KC
