We receive donations of food which are valued by pound. The value per pound changes each year. I'm trying to figure out the easiest way to have a "Donated Food Value" field that calculates this for us so that I'm not trusting people to do math. In 2022 food per pound was $1.74 and in 2023 it is $1.92. I want to be able to enter the number of pounds in the "Pounds of Food Donated" field and have the "Donated Food Value" field automatically calculate the value based on the close date. I also need to be able to add a new value each year. Is this possible?
Okay, if this is just a "once a year thing" and doing an annual update is not too much of a PITA
Then using a Formula like this, and then updating it each November should work. You can even build it out by adding ""placeholders" for future years, and fill in the values later
Donation_Weight__c *
CASE( YEAR ( CloseDate ),
2020, 1.87,
2021, 1.70,
2022, 1.74,
2023, 1.92,
2024, 0,
2025, 0,
2026, 0,
2027, 0,
2028, 0,
2029, 0,
NULL )
