Setting an entire Project Sheet to On Hold
I'm sure someone has encountered this but I'm curious if anyone has done anything with setting an entire project "On Hold" so that it reflects in the rollup sheets/dashboards. For reference, we are using the PMO template to base our projects off of.
What we would like to be able to do is put a new row in at the point of when the project was determined to go "On-Hold" and have it change all the "Not Started", "Upcoming", and "In Progress" statuses to "On-Hold". On the row, the user would put the "Start Date" as the date the project went on hold, but leave the "End Date" blank as it would be unknown. Or possibly, a future date that they think the project will start up again.
I think we can do this relatively easily with automation and a check box but reverting it back I think would be the challenge.
Thoughts? I'd love to hear/see how others tackled this obstacle.