When we met these folks in person, we were just as amazed by their kick-ass passion for people and planet, as we were by their jaw-dropping fundraising. Bravo to our top fundraisers for going above and beyond fundraising for the Climate Ride cause!
It takes dedication and hard work to achieve fundraising goals at any level and we are grateful to all of our participants for their efforts. Thank you for all you are doing for the betterment of our planet and all of her residents.
How to update the Hall of Fame on website: 1. Download in DonorDrive: “Fundraising Hall of Fame” in participant registrations report in Donor Drive A. Update the data tab here: https://docs.google.com/spreadsheets/d/1gXl8Y1kpDBO3PKlcW5GZf4Ns3DrebwrJypV4MpoOKuE/edit?usp=sharing B. Update the table press charts as needed
2. “All time Team Fundraising” in teams report in Donor Drive A: use to update Top 10 teams tab on website B: sort by sum donations C: update tables below
3. “10k Club cumulative” in participant registrations report in Donor Drive A. use to update Lifetime $10k+ Club tab on website B. create new column to combine first and last name =CONCATENATE (B2,” “, C2) C.Create new column that totals the number of events per participant COUNTIF (D:D, D2) D.Create a new column that totals the sum of fundraising for all events per participant SUMIF(D:D,D2,F:F) E.Filter all columns and sort by the sum of fundraising Note: with filter remove 1 from total events (uncheck 1). F. Update tables below
Awaiting the first member!
Congratulations to these fundraisers who have raised $25k+ over multiple Climate Ride events! All of these incredible fundraisers have participated in at least two Climate Ride events.
Δ