-
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 do I hide the sidebar/shared with bar?
Is there anyway to hide the left sidebar or workspace shared to bar in this new update? I can't see the names of anything unless I zoom out from the entire window.
-
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.
-
Multi-Sheet Cap for Reports/Pivots/Dashboards
Good morning, I need to report on data spread over 50+ sheets that are updated independently. The plan had been to place all these sheets in a single workspace and run a Dashboard or a Pivot referencing them all, but I cannot find whether there is a limit on the number of sheets a single Dashboard or Pivot can reference.…
-
Granting access to workspaces
Who grants access to workspaces/sheets? Staff A (admin) shared a workspace with Staff B, but the email to allow access to the workspace for Staff B came to me (owner). Can't Staff A who is admin of the workspace allow them to view it? Why did I only get the email and not anyone who is assigned at Admin status or higher?
-
Template Workspace / Copy Row Automation
I am using Control Center to deploy projects. Inside the template are workflows that copy rows to another sheet inside the same template. When a new project is made I have to go edit all copy row workflows as they continue to point at the template and not point to the new sheets in the new project. Am I doing something…
-
Need some help with a health formula for task risk level analysis
Hello, I am currently working on a formula for the health column in my smartsheet that is based on the the task status and the end date of that particular task. This is what I have so far but what I need is for when the "end date" cell is blank I would like for the health of that task to be blue. The reason is we do not…