-
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…
-
using dates in countif formula
Hi all, I have an issue, I need to use a collumn with autonumber system format, in this case i have used date. the problem ocurres when i need to count all rows created in a specific date, it seems that the systems does not count the dates with hours after 5:00 pm or assignes the next day date if the hours surpases 5:00 pm…
-
RACI Template
Hoping someone can help steer my in the right direction! IN the project managemet tools there is mention of an RACI template however when I log in it does not seem to be there? Am I looking in the wrong area or is this some secret enterrise level only template... Thanks Nik