Resetting a column to zero each week

I’ve created a scoring column on a board associates use to track activity on tasks. Based on any activity completed, the score is incremented by a predetermined amount via automation. I’d like to reset the score to 0 each week so I can view activity against weekly target scores. Is there any way to do this cleanly within the same board and group?