On a Agreement object I have End Date(date-data type) field , Auto Renew(checkbox), Terms months(number-data type), No of Terms(Data type-Number). End date should be updated based on Term month field when Auto Renew is checked.
For ex: If End date=14/07/2020 ,Contract Term Month= 12, no of terms=3, the end Date should be 14/07/2021 when Auto Renew is checked. On 14/07/2021 agreement should get auto renewed and end date should be 14/07/2022, on 14/07/2022 agreement should get auto renewed and end date should be 14/07/2023 and so on based on no of Terms value. No of Terms is for how many times it should get auto Renewed and based on that end date field should be auto updated with new value.
In Workflow condition I selected Formula evaluates to true and specified the condition i.e Auto Renew=True.Action part I gave the below condition. ADDMONTHS( End_Date_c, Term_month___c)
But I got stuck how to specify No of terms field.
Thanks in advance!