Custom Calculated Field - years since first gift

Hi Jamie! I don’t see a way for Custom Calculated Fields to take care of this for you. Is this a one-off message you want to send to donors or a recurring communication?

If recurring, I do wonder if a Workflow Automation could help though? My thought being…

1. Create a new Automation
2. Create a saved search that uses the Anniversary of first gift option in Contribution Summaries for step 1. You’d have to define your timeframe (e.g. tomorrow, next month)
3. Add a step to wait for a period of time
4. Add an action to send an email that has the language you want

This doesn’t allow you to populate a donor’s specific timeframe in as a merge field, but it lets you control what is being told and when it’s being told. You could add additional steps to wait longer and send more communications as the anniversaries continue. This is something you could edit over time too, so you can update your verbiage as needed to be relevant/timely.

Thanks, Charles!