-
Running a report with multiple sheets, columns not populating
Hello, I am attempting to run a report with multiple sheets and/or a workspace (I have tried it both ways) the criteria seems to work fine but when I attempt to show a column from one of the other worksheets it does not populate. Any suggestions??
-
Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage: Preliminary - 5; Negotiating - 3; At Lease - 7, etc... What would I…
-
Incoming and outgoing project sheets
I am looking to implament project controls as below One (1) workspace All project sheets (no sub folders) Project control Sheet Reporting (at risk tasks, high priority tasks, hours per resource) As projects start (need to be seen on the Project Control Sheet) and end (no longer are needed on the project control sheet),…
-
Is it possible to have all workspaces collapsed by default?
Our team is using Smartsheet more and more, which is great! But a few of us have noted that navigating is starting to become troublesome. It seems like the workspaces are automatically expanding out whenever we try to navigate to different folders. This is making it difficult to find some of the content - is there any way…
-
Transferring ownership of a workspace to client
Hi, I have a created a work space with customisation sheets for a client, but now I want to completely transfer that workspace to my client. How do I do that? without having him saving sheet as new? it should be the same sheet, just need to transfer ownership.
-
Copy folder error
I have created a folder containing 15 sheets with various links to reference sheets (outside of this folder) and datameshing. The idea is that I can copy the folder, change a cell reference (location) and the new folder will update with the reference data for that location. I've "saved as new" the folder and gotten an…
-
Change Management: Multiple projects > Consolidate into one
Hi there, I have multiple change projects to track within the general IT PMO along with other non-change projects. My goal is to consolidate them and list them underneath the 'change' category and so I'm trying to figure out the best way to organize them without listing them all out and clogging the other non-change…
-
Dashboard Calendar
Hi, I was wondering if someone would be able to point me in the right direction as to how you can create a dashboard calendar that can be displayed for everyone who has access to see. This would be used for project management and to track tasks and their completion dates. Kind regards, Sync
-
Sheet Linking - Project sheets to single metrics sheet
Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and analysed. The information & metrics from all projects should be collected in the Metrics sheet.…
-
Dashboard Sharing: Is there a way to check all the Dashboards I currently have published?
Hello, I've created a few Dashboards and published them for viewing. After viewed, I removed the publish option in order to stop anyone from acessing them. Is there a way to check all the Dashboards I currently have published? I wanted to make sure I haven't left any of them out.