Include Previous Update Request Response in Current Update Request
This is my first question asked on the Smartsheet Community and I'm hoping someone can help me, because this would greatly help our users. My boss and I run the HR PMO for our company, and we use Smartsheet to collect project updates for all active projects in the HR portfolio. Updates are requested from what we call our "Report Out Managers" (sometimes the PM, sometimes functional lead) every other week.
We use automation to send out these update requests, and then we use another automation to clear out the responses before the next request is sent out. A screenshot of what the request looks like is shown for reference. Every other week, we ask for an update on the 3 fields shown in the red box.
However, often people can't remember what they put the last time, and if they are responsible for providing updates on more than one project, this can be quite a difficult thing to keep track of.
We were asked if we can update the notification to include the response they inserted in the previous update. I have tried to figure this out without creating another column and manually copying the updates before the cell is cleared. I am not seeing a way to do this in a non-manual fashion. Has anyone found a solution?