-
Can you copy specific rows to a new sheet without bringing over child rows?
We do our weekly reports (Good, Brutal Facts, and Help Needed) within SmartSheet (Have 5 levels of Hierarchy with "+" and "-" icons), and our process has gained traction with other teams. We are looking at how to scale our process to accommodate another level of leader (Currently goes from Managers -> Director and Director…
-
Formula when a column has a checkbox
I cannot seem to find this answer: When a column has a checkbox, another column must have data in it or it will turn red Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red. On Site Person <star> Contact List or cell is RED
-
Are Admins the only ones who can create new sheet from Template?
We would like to have one of our Editors have the ability to create new sheets from a template in the workspace they're shared to. However, it appears that only admins have that ability. This seems unsafe for workspaces that have a lot of customization that could be modified by a user that really only needs Editor…
-
Publishing a dashboard, "owners account" definition?
My company has an Enterprise account. I am the owner of dashboard in question, the workspace that the dashboard is in, but I am not the Enterprise account "owner". So my question is, who exactly are the users in the owners account? Do they have to be specifically shared by the admin/owner of the Enterprise account, or just…
-
Sharing - Permissions by Subfolder or Workgroup
All, I want to create a structure (I don't care if it is a folder or a workspace) for a project with 3 sheets and 2 subfolders. Each subfolder contains 2 additional sheets. I want to share the project structure with my customer, but I don't want to share the subfolders (one folder has financial information and the other…
-
Sharing a sheet via an automation
Would be great if it were possible to write an automation which would automatically share the sheet with people named in cells in the sheet. Ideally with controls to editing rights, etc. Certain reports we make need to be shared with three particular individuals in the organisation but are intended to be confidential. At…
-
Merged: Create "Current User" charts on dashboard without sharing underlying data
This discussion has been merged.
-
Share Partial Workspace
When I share an object with another user, I want them to see it organized within its workspace, not under their "Sheets". If I have Workspace A, which inludes 50 sheets and I only share 1 sheet with User1, I want User1 to see Workspace A with only 1 sheet in it. The organization of the current configuration is a nightmare…