I'm trying to find a way of updating the column Term Expiration Date with the New Term Date column. I currently have a workflow that once a date is entered into the New Term Date it copies that row to a new sheet.
The problem that I am running into is if I use the Data Mesh, or Data Shuffle it tends to update automatically. If I use a function of =if the Term Expiration Date will either be blank or be copied to the new sheet.
I'm currently setting up a metric table that calculates the days between those 2 dates.