Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Approving Changes Made to A Shared Sheet
Hi all, long-time listener, first-time caller.
I have been tasked with discovering a way that a sheet owner can control updates being made to a shared sheet through some form of 'approval' feature or process.
My scenario is this: there is a master sheet displaying all approved, company-wide projects, complete with columns for resources allocated to each project, project/resource start and end dates, color balls tracking schedule, cost & scope and a few other static columns used to document the parent row level (project name).
The sheet is shared with all resources (Viewer) and Project and Portfolio/Program Managers (Editor). The issue has been some PMs have updated resource allocation percentages (as most resources are bing used on multiple projects for X amount of time) on other projects, along with other data fields which has created a free-for-all environment, if you will.
Aside from locking columns that can be edited, or spitting the projects into their own sheets and setting permissions there (too many sheets will need to be created), is there a way to have the sheet owner approve a change that is submitted, enabling the updates to populate the field, or reject an update, disallowing the field to be updated?
My idea was to duplicate the master sheet and share the duplicate; receive alerts on updates to the duplicate and somehow link those approved changes into the master sheet (which is viewable to the Execs). However, upon thinking of this solution, it seems that there is a high level of manual effort for the sheet owner, which is what we want to avoid. Is there a workflow/check-box/formula solution? Web form that can update cells instead of adding a new row? Or other ideas?
Thanks in advance for the feedback.