LYBNT/SYBNT/etc. IF/THEN dashboard

A dashboard using IF/THEN formulas to look at contribution data. 

  1. Did they give Last Year, but not This Year? If so, show Last Year's giving.
  2. Did they give within the last 2-5 years, but not This Year? If so, show Last Year's giving.
  3. Did they give 6 or more years ago, but not This Year? If so, show Last Year's giving.
  4. Did they give in 2020, but not 2021? If so, show 2020's giving.