Can I set up an automation to archive a project from within a sheet inside the folder project?

We're looking for a more efficient way to archive our projects. I was wondering if is it possible to set up an automation inside a sheet (Let's say inside the Project Charter template) triggered once a box is checked by the PM to archive the whole folder and disabled the automations from other sheet. Any one has done something similar?