I am hoping that someone can provide some insight to complete the request that has been asked of me.
First my SharePoint scenario is 2013 on premise with Nintex Workflow 2013.
What I have been asked to do is the following:
1. I have a custom list called SR Tracker. This list tracks a groups customer service review calls. When they happened, when the next call should happen and the service review ticket. An example is seen below:
2. I need to find out information from two columns. The items highlighted in yellow is a column called Call Status. The items highlighted in red is a column called Next QSR MM/YY.
3. I need to find out the most recent item in the Call Status column and then display the date (such as April 2016 as seen above) from the Next QSR MM/YY field in another field on the Customers custom list.
I need to know what is the best way to grab this information and get this information put into the other field in the Customers list.