-
Column Editing Restrictions
Hello, I have approximately 50 users that routinely review and update the data in columns in my SmartSheet. However, for 3 columns in my sheet, I need to restrict 47 of my 50 members from being able to update the data in those specific columns. The rest of the sheet can be updated by any user. Locking the column allows…
-
Specific Dates in Columns
Hello, I have a column that users must input a date that their project will attend a specific meeting. This meeting only happens on set days every month, so I am wondering if there is a way to only allow a user to choose/put a specified date in the cell for that meeting. For example, if that meeting happens on August 9th…
-
Assigning new users to groups
I used to be able to assign new users to groups when I created their account. Something seems to have changed, and now I can't assign them until they've accepted their invitation. Any ideas? It's a pain for them to contact me once they've logged in for the first time so that I can then assign them to the appropriate groups…
-
Granting full Admin Permissions
I have taken on a new role in my organization and will be managing much of our content and data on our Smartsheets--which has already been in place and established with content prior to my arrival. I am finding myself very limited to what I can edit and share with already existing sheets (even though I have been made…
-
Data quality issue: List tasks assigned to 'unregistered' users
I want to resolve two issues; prevent people from exacerbating the existing issue and rectifying the legacy DQ issue 1) How do i prevent users assigning tasks to people who are not registered in Smartsheet? Is there a way of forcing them to select from the drop down list? 2) Whats the best way to audit all tasks assigned…
-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Using Webform to update/edit information of a row
Is it possible to use a look up function in a Webform to find a specific row of information, then populate fields related to that row, and make changes in the Webform to modify the related information to the row in SS?
-
Automate End Month Date
Hi , I have started a Sheet to manage tasks for of the payroll Firm's I run I need to get into 1 cell automatically last date of the month so if its February its the 28th if its Jan should be automatically the 31st Which formula can I set up that it should automatically be set for end date of the month? so i can get set…
-
Adding information to templates
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year. My current plan, was to create a Template, then have a sheet for each person. This way I can request them to…
