-
Form Search and Auto-populate values
Hello, I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference…
-
COUNTIFS parsing error
Hi, I reviewed the other countifs suggestions, but i am still getting a parsing error. I am trying to count all rows that have EBS in range 1 where range 2 has only completed and in process. =COUNTIFS({2018 TRACKER Range 1}, "EBS", {2018 TRACKER Range 2}, "Completed", {2018 TRACKER Range 2} "In Progress")
-
Removing/Adding people/resources in card view
Hi there! I am seeking some advice on how to ensure that when you add someone in Grid view that they show up in card view as well. I am also needing some advice on how to remove someone who has nothing assigned to them from the "Assigned To" view in card view. Is this possible? Thanks in advance!
-
Transferring ownership of a workspace or sheet
I am trying to change owner of a work space to any other licensed user. The option to remove me as the owner or change the user from admin is not available at either the sheet level or workspace level. Has this changed since the last round of upgrades?
-
How to configure a project assignment and the assignment date and show the rest of the fields diseab
I have a problem. When Smartsheet sends the form on request to an area. I need to know if after receiving a project from a form, to be able to assign a resource and the date of assignment I can only do it from an update? or there are other ways of being able to assign people and date of assignment, automatically without…
-
Enterprise Edition - User Management
Does anyone know how user management works in the enterprise version of Smartsheet. I am needing the ability to manage all user access, and not allow individual users management access.
-
How to change Work spaces Ownership
Hi, I am having some trouble with changing the ownership for workspaces between licensed users. I am an Admin and have workspaces that I now own but need to transfer to someone else to own. I don't want to transfer all my workspaces, just a few . Thanks,
-
Want to change our View By in Card View
When I am in Card View I would like to "View by: Assigned to" but the only option is Status. How can I get our Assigned To column when in Sheet View to act as the View By priority?
-
Renaming of attachments?
Good morning, I did a search in the Community, so apologies if this has already been addressed. Is there a simple way to rename attachments? We have several Word/PDF attachments and need to rename them to our internal naming convention protocol. The only way we've found is to download the document, rename, upload and then…
-
Invalid recipients of notifications removed from SmartSheet sharing access
I'm using alerts/notifications and getting false positive alerts about invalid recipients who happen to be on vacation with automated out-of-office replies. I get an alert as shown below with steps to change permissions for including the inactive users in the automated notifications that were originally set up. The funny…