Need help with a Formula field on Case Object

Question

So I created a formula field based on the Contact.Last_Activity Field so we could see when was the last time an email was received on a Case. The problem is that there is other activity on a Contact record besides the Case emails. Is there a way to build a formula that references the Case Id and the Contact.Last_Activity fields. This is what I have built so far. I tried to add an AND to each IF statement and was getting an error. Any thoughts?

IMAGE(

If(

Contact.LastActivityDate < TODAY()-5,

"/servlet/servlet.FileDownload?file=01540000001DGzT",

If(

Contact.LastActivityDate < TODAY()-2,

"/servlet/servlet.FileDownload?file=01540000001DGzN",

"/servlet/servlet.FileDownload?file=01540000001DGzL"

)

),

"Communication Level Flag"

)

Cheryl Besch · Answer

I think I understand where you are going with this suggestion.  Let me give it a try.

Need help with a Formula field on Case Object

Data Management

相关学习

更多帮助