- Sharing folders
Since Workspaces is not conducive to individual permissions, we are trying to use the standard folders under "Sheets". One department has close to 100 files in Smartsheet. We want to use Smartsheet in other departments as well, but would like to organize the departments by folders. With each Sheet, Report, and Dashboard…
- User Groups and Auto-Provisioning Users
Is there a way to auto add users to a default group during auto user provisioning? We've added domains and verified, and i can turn it on and set them to free or licensed, which is great. but how do i get the new users to automatically be added to our workspace? I was thinking of sharing a ALL-Company group to the…
- Share a sheet with all users
At my company we have a few hundred users. They are all divided up into departmental groups also. Is there an easy way to share a sheet or workspace with all users at once. All I see in the list are all the departmental groups and the individual users. Nothing like an "Everyone" selection or something similar to that.…
- Allow assigning users to groups during account creation
It would be nice to be able to add a user to a group when creating their account. In the current set up it is two step process so many users end up not getting assigned to groups. If this was coupled it would make the user and group management more effective.
- Allow BRANDFOLDER attachment option to be configured in Admin Center
"Brandfolder" is not currently provided as an option for attachment configuration in the Admin Center. (E.g., A SysAdmin role cannot turn this attachment option on or off.) We have not purchased Brandfolder. My current client has high security requirements, and only allows documents to be attached to a sheet via the "URL"…
- COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
- Delete user account
I followed the instructions to delete the user account, however my issue is that the user that I am trying to remove is not on the User Management screen. However the user is still showing on the "Workspace Shared To" list. How can I remove this user from Smartsheet all together? Thank you!
- How can I add a number of days to a date column in the same sheet?
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
- How do I take information from two sheets and auto populate into a third sheet?
I am trying to set up this smart sheet where it has a entity that someone can select from a drop down menu. Once they clicked any entity I had it V lookup from another sheet and it would auto generate the address for that entity from a different sheet into the cell next to it. I figured out how to do this part. I am…
- List of workspaces, sheet, dashboard, report with its owner information
Is there a way to get a list of workspaces, sheet, dashboard, report with its owner information? How to manage all the item in an account? Thanks in advance
