-
Merged: Workspace Hiding
This discussion has been merged.
-
Workspace Permission Changes and Sheet Ownership
Hi, we changed some permissions on a workspace (made some Admins into Editor Can Share). It appears that when we did that, if they were the Owner of a particular sheet in the workspace, ownership was transferred to me. I am the sole Admin of the workspace but I am not the Owner of the workspace. Why did ownership of the…
-
IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…
-
How to remove user access for specific dashboard without effecting Workspace?
Hello, How can I remove an unlicensed user from specific dashboards without having them lose access to the workspace? Thanks,
-
What is the best way to copy Workspaces
Hi everyone, I am looking to create copies of some of my Workspaces and am facing 2 different issues. The 1st issue is I have a large interconnected Workspace with over 200 items inside it. I need an exact copy and don't want to relink everything as I would need to do this multiple times and would be days of work. The 2nd…
-
Automation changes?
I had an automation setup to copy a row from one sheet to another that has suddenly stopped working. The trigger sheet lives in a different workspace from the destination sheet but that has always been the case. I am an admin on both workspaces. When I attempt to fix (or even create a new) the trigger, the list of…
-
Managing Multiple Projects? Project Hub & Workspaces
Hi, I've set up a Project Hub using a template set - in a new Workspace - so that we can see all Projects in one place and, when needed, be able to see Reports for overdue tasks across all Projects rather than having to go to each individual Project for a Report. Now want to move some existing Projects into it, but I see…
-
Transferring Ownership of Multiple Sheets/Reports/Dashboards at once
Hello, I've got a scenario where I helped a user (let's call him User 1) create a process, however, he (User 1) has switched positions and it is time to reassign ownership of things to another individual (User 2). Between me and the original user (User 1), we created all the sheets, reports, and dashboards in the…
-
How to count tasks across all sheets in a workspace
I have a master metrics sheet that I am using. I'd like to be able to count tasks by assigned to across all sheets in a workspace. The goal is to have this formula work if/when any new sheet is added to the workspace. Reports are not really working for me because my assigned to column is a multi-select column. I don't see…
-
Main use of workspace vs view resources?
I am new to Smartsheet and I am kind getting confused by what purposes do both workspace and resource view serve. Thanks.