-
Managing Cross Sheet References at the Workspace Level
Today, cross sheet references must be managed within an individual sheet. I'd like to be able to implement and manage cross sheet references at the workspace level as well. Use Case: 3 sheets containing unique data, but identical columns that are fully replaced weekly; 2 reports generated from those 3 sheets. The 2 reports…
-
DASHBOARD - Shortcut Widget - changed?
I set up a Dashboard many months ago and it allowed me to put Links to WORKSPACES and FOLDERS from the SS Directory. See the Screenshot. I went to update the DB / add another FOLDER, and it would not let me. I had a consultation with a smartsheet basics person on the phone. They said not allowing WORKSPACES and FOLDERS is…
-
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…
