Filter Issue, not applying

Tony C. shared this problem 12 months ago
Solved

I have created a filter to sort all our Leads/events so my staff can easily see what is happening tomorrow.

I am not currently using the logistics so I need an alternate solution.

We have 3 confirmed statuses. Reserved (need signature), Confirmed, and Confirmed Customer Pickup.

I created a filter that is supposed to pull any lead with one of those statuses AND with an event date within the next 30 hours.

So, basically, if we pull the report at 2pm it should cover anything happening between 2pm today and 8pm tomorrow. (at least in my mind)

The problem is, when in leads and I sort using the filter, it shows all leads with the confirmed statuses. The filter does not seem to recognize "The next 30 hours". It shows stuff 2 months from now.

Attached is the filter I created. From my knowledge it should do all the OR items first then apply the AND for a final qualifier.

Any help appreciated.

Comments (4)

photo
2

I think you need to separate your filters into groups. Hang on a sec

photo
2

72476c714c4885b47aaafd5ab8e1ddba

photo
photo
2

Casey is correct.

photo
1

How do we make this "Best answer"?

photo
1

yea my best answer options never show up anymore maybe the took that away form us Casey

photo
photo
1

Thank you!

Works like a champ


Thank you again

Tony

photo
1

A lot of people forget this!

Leave a Comment
 
Attach a file