I'm trying to capture a list of donors who have given annually (at any level) for 5-7 years. I'm not sure of a simple pre-loaded way to do that, so I'm looking for guidance. Any thoughts?
Thanks so much!
Beth Levy
Hi, Beth:
You can use lists. Make a separate list for each year’s donors. Then, set up a list that uses them all as separate lines:
CRITERIA OPERATOR VALUE
List Has [current year’s donors]
List Has [last year’s donors]
List Has [donors from 2 years ago]
List Has [donors from 3 years ago]
List Has [donors from 4 years ago]
The result should consist of only those who gave in all years.
Lucie
Awesome! I was trying to wrangle something in this direction, but missed the final piece of the puzzle. Thanks for this.