Dashboard- weekly project status submissions
I would like to create a monthly dashboard that displays which project managers have submitted their status each week. I have a master Project Management Sheet where project managers submit their status. I plan to have an automation that clears whatever the project manager has added , in order to make room for their new status the following week. My question is, how would I be able to track their weekly submissions and report on them, if they are cleared every week? I would sincerely appreciate any advice, tips or tricks.