I have created an awesome base to run agendas for my team. People can submit topics, I can print them a pdf of the weeks agenda, take notes on the meeting, and create action times. I also have views for each member of my team and meeting so I can run automations to remind them to submit topics two weeks out and the day before.
I want the ability to be able to automatically carry over the notes & action items (each their own column) from the previous meeting to the next meeting so the agenda printed has those items in it.
How can I create a formula that automatically carries over items from the previous row essentially into a column on the next row?