Can I consolidate a weekly single cell update to another cell to keep history viewable?
Hello! We are trying to move our Excel spreadsheet into Smartsheet for project status updates. Current process is that every Tuesday we keep adding comments manually to the Excel cell for at least 6 weeks. I set up a workflow in Smartsheet that sends an update request to the PM every Monday and the comments are added to the "current week notes" column in the sheet. I can set up automation to move that cell data to another column but can't figure out a way to keep that data history for more than the 1 week since the formulas I've tried keep erasing the historical notes. We would want to know the date the comment was made as well. We report out to leadership the project's history so keeping the comments in a readable format is important. First image is current state.