-
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
-
Baselines
Hi there, I have a query that I'm hoping someone will be able to help with - when adding a new activity to a project plan how do I ensure that the variance is tracked without resetting the baselines for the whole project? I am finding that if I add a new activity its baseline start and finish are not automatically…
