-
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…
-
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…
-
Dynamic View Tricks for Common Painpoints
I've been using Smartsheet's Dynamic View to streamline and automate workflows in my organization, which has led to stakeholder onboarding that has scaled to a large group of external users. There are common complaints that have surfaced from both new and existing users, which makes me curious about workarounds the…
-
External collaborators with expiration date
In bigger companies often external collaborators are invited for a project. Easy to achieve. For lots of projects with hundreds of internal and external collaborators it would be very helpful if an admin could either set an expiration date, or at least a reminder to check if a specific collaborator should be removed.