Best Of
Multiple Workspace Owners in Smartsheet
As a Smartsheet Control Center (SCC) admin for a large-scale Project Portfolio Management (PPM) implementation, I’m requesting support for multiple workspace owners or enhanced administrative permissions that allow licensed Admins to move folders and assets between workspaces they administer.
Currently, Smartsheet restricts folder and sheet moves between workspaces unless the user is the Owner of the destination workspace. Even with Admin access and content ownership, users are blocked from moving assets unless they own the workspace itself.
This limitation presents a major bottleneck in our provisioning process, especially in environments where project workspaces are centrally owned by a PMO or system admin, and provisioning needs to be delegated to program managers or leads.
Use Case:
In our environment:
- All project folders are provisioned via SCC into a staging workspace.
- Select TPMs are assigned Admin access to both the staging and destination workspaces.
- Select TPMs cannot move it into the final destination (e.g., ABC workspace), because they do not own the workspace.
This results in:
- Delays in provisioning due to dependency on a single admin
- Inability to scale folder moves across Workspaces
- Governance challenges and additional process overhead
Feature Request:
Support one of the following enhancements:
- Allow multiple workspace owners so responsibility can be distributed to provisioning delegates.
- Allow licensed Admins with full workspace access to move folders into workspaces they administer (regardless of ownership).
- Introduce custom roles or granular permissions for folder moves across workspaces within the same organization.
Impact:
This enhancement would:
- Unlock scalable provisioning workflows for distributed teams
- Reduce manual effort and dependency on a single admin
- Align workspace management permissions with enterprise-grade collaboration needs
Calendar Y/N Toggle
I have a sheet I use for PTO. On that sheet is a Checkbox labelled "Delete" (first image). I render the dates on the Calendar app (second image) and then when a user double clicks an item they get the details sheet - allowing them to select "Delete" (third image). Why does the checkbox appear as a dropdown? I just want a toggle (yes/no), which is what I setup on the sheet.
Re: INDEX LOOUP Workaround
@APicard_AZ I would suggest putting it all in one sheet and then having two reports (one for production and one for qc). The reports will allow users to interact with the sheet but still allow you to only display the columns that are needed for each.
Paul Newcome
Re: INDEX LOOUP Workaround
Hello @APicard_AZ!
Just tagging you to make sure you don't miss Andree's response!
Marcela
Re: INDEX LOOUP Workaround
Hi,
I hope you're well and safe!
1️⃣ As you mentioned, you could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.
2️⃣ Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet, use my previous method to get the values you need to another helper sheet, and then copy/move the row from that sheet to the main destination sheet.
To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row ID on as many rows as you need in the Destination sheet.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Re: Pivot App is not recognizing the Contact Columns
I am having the same issue. It has worked for years, but not now.
Display Report Summary Gantt
Currently, when you do a report summary, it will pull in tasks from multiple sheets and group them per selections. It shows the Gantt chart of each of the tasks, but does not show a bar for each of the summary groups—I would like to see it work the same way subtasks work on a regular sheet, where it shows a bar from the beginning to end of all subtasks in the group.
Re: What size image, width x height, is best for a background logo on a form?
I have this issue. I don't understand why it's hard to get an answer on what is the size that you should make the image to avoid distortion.
Re: Request for Rollback - create sheets in Sheets folder
@Emain123 ya, no suprise there, you can see how they responded early on in this very long ongoing topic - see link here 😒
Julie Becker
Re: Lock a date even if it has predecessors
Having a Gantt chart option puts Smartsheet in the same realm as MS Project. I was surprised that there was no way to lock a milestone. It is one of the most critical features of scheduling. Can I upvote more than once?