create a google sheet donation management sheet
Budget: $30 – $250 USD
I am looking for a freelancer to create a Google Sheet donation management sheet for my organization. The sheet should have the following features:
- Donation tracking: I need to be able to track the food needed VS the food donations received, and who donated it.
- Donor information: It should include a section where I can enter and update information about the donors contact, and notes.
Cash donations: I need a sheet that will track money donations
I would like the sheet to automatically update in real time, so any changes made by me or other team members will be reflected immediately. All sheets should be connected, so I can only need to add data in one area, and use that data where it is needed in other areas.
Sheets:
1 Sheet with all donor info (donor name, company name, phone, email, address)
2 Sheet with all food items needed, (Food Name, description, Quantity needed, Quantity Size, Food donated[connects to the donation sheet that updates what has been donated for])
3 Sheet with all volunteers (Volunteer Name, Phone, email, Position [dropdown list of all positions from another sheet], Notes)
4 Sheet where all donations (Donor name [From Donor sheet, what was donated], Food donating [pick food from food item sheet], quantity donated [pick food from food item sheet], pick up donation date
5 funds donation Donors Name[From Donor sheet, how much was donated], date donated, who picked up the donation.
Ideal skills and experience for this project:
- Proficiency in Google Sheets and advanced knowledge of formulas and functions and app scripts.
- Experience in creating custom templates and automation in Google Sheets.
- Attention to detail and ability to create a user-friendly and visually appealing sheet.
- Strong communication skills to understand and incorporate my specific requirements into the sheet.
- Donation tracking: I need to be able to track the food needed VS the food donations received, and who donated it.
- Donor information: It should include a section where I can enter and update information about the donors contact, and notes.
Cash donations: I need a sheet that will track money donations
I would like the sheet to automatically update in real time, so any changes made by me or other team members will be reflected immediately. All sheets should be connected, so I can only need to add data in one area, and use that data where it is needed in other areas.
Sheets:
1 Sheet with all donor info (donor name, company name, phone, email, address)
2 Sheet with all food items needed, (Food Name, description, Quantity needed, Quantity Size, Food donated[connects to the donation sheet that updates what has been donated for])
3 Sheet with all volunteers (Volunteer Name, Phone, email, Position [dropdown list of all positions from another sheet], Notes)
4 Sheet where all donations (Donor name [From Donor sheet, what was donated], Food donating [pick food from food item sheet], quantity donated [pick food from food item sheet], pick up donation date
5 funds donation Donors Name[From Donor sheet, how much was donated], date donated, who picked up the donation.
Ideal skills and experience for this project:
- Proficiency in Google Sheets and advanced knowledge of formulas and functions and app scripts.
- Experience in creating custom templates and automation in Google Sheets.
- Attention to detail and ability to create a user-friendly and visually appealing sheet.
- Strong communication skills to understand and incorporate my specific requirements into the sheet.