A dashboard using IF/THEN formulas to look at contribution data.
- Did they give Last Year, but not This Year? If so, show Last Year's giving.
- Did they give within the last 2-5 years, but not This Year? If so, show Last Year's giving.
- Did they give 6 or more years ago, but not This Year? If so, show Last Year's giving.
- Did they give in 2020, but not 2021? If so, show 2020's giving.