I have a SharePoint list that is populated with ticket data. There are two primary columns "Open Date" and "Calculated Date" I'm trying to figure out how to set the calculated date 2 weeks out from the open date and every two weeks thereafter.
Essentially, I'm using Microsoft flow to automate a process. The flow will check the ticket status if it reads open it will look at the open date and kick an email off two weeks after the open date. For example say ticket 1 is opened as of today 4/16/20, the flow will check the ticket status if it is open it will look at the open date and there will be conditions set to send an email 2 weeks after the open date. However, I will also need it to send an email every two weeks after until its closed. 4/16/20 open date > email 4/30/20 > email 5/14/20 and so on until it's closed.
Essentially, I'm looking for a way to have imported dynamic date data and a calculated date column that always reads two weeks from the imported dynamic date data. For example the imported data would be "last ticket update" ex. it's entered into SharePoint as 4/16/20 I would like another column "calculated date" to be able to change dynamically 2 weeks out from the "last ticket update." A ticket will be entered into SP with a date and status if the status remains open I need the calculated date column to be every two weeks to send a reminder. I hope that helps explain what i'm trying to do.