Sacha
Contributor
2021-06-25
05:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Formula contains help
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,
791 Views
4 Replies
tresesco
MVP
2021-06-25
05:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
777 Views
Sacha
Contributor
2021-06-25
05:24 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]))
763 Views
tresesco
MVP
2021-06-25
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, Give a try. Ohhho, a bracket correction might be needed.
and Index([Lead.LastName]), 'sale at 3') and // remove
749 Views
Sacha
Contributor
2021-06-28
03:46 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help Tresesco. It works perfectly
657 Views