Formula contains help

[Sacha]

Dear community,

In this formula I would like to add one more condition

count(aggr(if(year([Lead.CreatedDate]) = year(today()-1) and month([Lead.CreatedDate]) = month(today()-1) and [Lead.OwnerId] <> '0051t000004EGlIAAW' ,1)
,[Lead.Id]))

I would like to say in the formula that Lead.LastName contains "sale at 3"

Can you help me?

Best Regards,

[tresB]

---

@Sacha wrote:

.. Lead.LastName contains "sale at 3"

Try like:

Index(Lead.LastName, 'sale at 3')

[Sacha]

Hi Tresesco,

This one?

count(aggr(if(year([Lead.CreatedDate]) = year(today()-1) and month([Lead.CreatedDate]) = month(today()-1) and Index([Lead.LastName]), 'sale at 3') and [Lead.OwnerId] <> '0051t000004EGlIAAW' ,1)
,[Lead.Id]))

[tresB]

Yes, Give a try. Ohhho, a bracket correction might be needed.

 and Index([Lead.LastName]), 'sale at 3') and              // remove

[Sacha]

Thank you for your help Tresesco. It works perfectly