Return checkbox column to initial state after project scoping is complete
I'm trying to figure out if/how I can return a checkbox column to it's original state once a user has completed scoping a project. I've tried just about everything and keep running into roadblocks given my level of Smartsheet knowledge.
For context: I've created a project scoping sheet that contains rows for all deliverables my team creates and columns for our three project tiers. Some deliverables are included in all tiers, while others would only be included in Tier 1, or may be greater in number in Tier 1 than they are in Tier 2, for example. The sheet also has columns for each role on our team that contain the estimated hours that role contributes to each deliverable (by row). I've created checkbox columns for project Tiers 1, 2, and 3 that are pre-populated with the deliverables normally associated with that project. PMs can check/uncheck boxes within the Project Tier columns to autocalculate their hours estimates.
What I'd like to do is provide them a way to return the project tier checkbox columns (Tier 1 in the screenshot above) to their original state with the appropriate deliverable boxes checked or unchecked based on our defined template. Does anyone have an idea as to how I might accomplish this?
Help Article Resources
Check out the Formula Handbook template!