Skip to main content

I’m trying to track the dollar amount of a donor’s remaining pledge. Say they pledge 500, then donate 150, then donate 75. I want a formula that will calculate the remaining pledge as it goes down. Thanks!

Hi @Althea_Barton - here’s how I would do this:



  • have two tables - donors and donations. The tables are linked by the donor field:




Record each individual donation on the donations table (with additional data such as the date if you want).


Back on the donors table, you can do a rollup to get the sum of the donations in the donations table by donor:



You can the have a formula field that takes the total donations from the pledge amount giving you the amount left to donate.


JB

Reply


Terms & Conditions