-
Help with Global Update for rows added across 2 columns already updated on master sheet
I added 5 rows of data (across 2 columns) on one sheet of our current control center template and want to do a global update to edit all our workspaces. I was able to do GU for the new columns i added but don't know how to do same for new rows. One of the new row cells includes a formula as well. When i select the modify a…
-
Efficient Monthly Report Data Collection System for Faculty using Smartsheet
I am looking to create a streamlined system in Smartsheet to collect monthly report data from faculty members efficiently. This would include updates on publications, grants submission, presentations, etc. The main goals include consolidating all of this information in one place, providing a user-friendly interface for…
-
Error when trying to transfer Workspace Ownership
I'm a system admin and needing to transfer the ownership of a Workspace over to a Licensed User however when I go through the standard steps (Sharing And Collaboration --> Workspaces --> Transfer the ownership of a workspace) I get the error "This user cannot accept ownership at this time. Please retain your ownership or…
-
Copying Dashboards to a second Workspace
Currently, I have a Workspace (I will call Workspace 1) that has been shared with others. However, I want to create a second Workspace (Workspace 2) that only includes viewable dashboards from Workspace 1 (no sheets, reports, etc). I want this Workspace 2 to only be able to be viewed not edited. If I put the dashboards in…
-
Proper Safety Management System (ISO 45001)
Has anyone created a successful Safety Management System using smartsheet? If so, do you have a template?
-
How do I prevent a category from showing up multiple times in a Pie/Donut Chart?
I made a pie chart from one of my sheets. I wanted to show how much was spent based on each category. However, in the widget it shows two of the same category in different slices. I'll include an example. Why is eLearning showing up as two separate parts instead of combined? Its the same category.
-
Request Access Notification
I provision all projects for our PMO and each project is housed in a Workspace to control access, so, I am the 'owner' for each project in our organization... This setup worked for a time, but now that we're scaling up, I'm receiving access requests for projects almost hourly. Unfortunately, the way we have our project…
-
Projects deleted via Control Center still showing in Browse window
I deleted a number of projects via control center and all seemed to work as expected. The projects no longer appear in Control Center, on the Intake sheet, or the Portfolio Summary sheet. The project do still appear in my homepage in the Browse column. When I try to select the project in the browse window there is no…
-
Workspace Cell References
It would be useful if you could create / manage a table of workspace cell references. For example, I have a base sheet that then is referenced by many break-out sheets within the workspace using external cell references. For something like "Site ID" in the main sheet, setting up a consistent workspace cell reference of…
