Hi James, would you be open to changing your base layout?
Having a table that just has
End Date and a
Notes field to handle data entry about pausing and restarting etc, followed by a rollup field to sum the years of service would be much easier to set up for you to get what you need, and would also solve the potential issue of a volunteer that pauses more than once
If you’re set on using your current layout it’s definitely possible to create the formula, you’re just going to end up with a lot of nested