I’m looking for some help. We have a custom date field that is applied to members of an institute. We are trying to automate the renewal process so that when somebody renews their expiry date is updated by 12 months.
I’m really struggling to get this to work.
My approach is to use Google Sheets to provide the calculation. So I need the existing expiry date to be entered into one cell, and then the next part of the automation updates the contact with the new date from the same SS.
Is this possible?