-
Can you create an automation to automatically enter links in one sheet to a template?
Currently, we have a sheet created from a form that we add hyperlinks to from a template we create to reflect the project health, status, and then manually hyperlink the template to this sheet. We would love to run an automation that will automatically create a template and automatically enter these hyperlinks to the sheet…
-
Does anyone have a simple RFP Scorecard Template they can share?
Hello everyone, I am hoping someone out here can help me. I need a simple RFP scorecard template. Has anyone developed one that they can share?
-
How to create a dashboard metric widget to automatically obtain the data template？
Dear friends, I am using the dashboard metric widget to obtain data, but I have not found a way to reuse it, it cannot use functions. I can create a new project form through a template, but when I use the dashboard, I have to re-select the data source. To obtain data for a new project, is there any good method to suggest…
-
Why would you save a sheet as a template vs saving as a new sheet?
I have a master sheet that I plan to replicate multiple times retaining all configuration I have done ie workflows, attachments, predecessors. It appears that saving as a template and saving as a new sheet would retain all of those features. So what is the benefit of saving as a template vs saving as a new sheet (and vice…
-
Setting an entire Project Sheet to On Hold
Hi all, I'm sure someone has encountered this but I'm curious if anyone has done anything with setting an entire project "On Hold" so that it reflects in the rollup sheets/dashboards. For reference, we are using the PMO template to base our projects off of. What we would like to be able to do is put a new row in at the…
-
Copy & paste tasks and dependencies
Hey everyone, i have created a template task list including their dependencies and I would like to copy and paste them in my sheet, so I don't have to figure out the dependencies for every bucket on its own. However, It appears I cannot copy and paste the dependencies :-( - is there any way of doing this in a better way or…
-
Template for repeat tasks
We have a one Smartsheet for a list of different type of training events we run throughout the year with associated tasks. We have templates at the very bottom of the smartsheet, to copy and paste, for different type of events and the associated tasks. Is there a way to save these templates and also have certain tasks to…
-
Project management template packet- Forms Included
Hello, I have generated a 'Project Management Template Packet' to be re-used by Project Managers each time they begin a new construction project. One important item we use is an RFI Form- used by field personnel to generate 'requests for information', which populate a Smartsheet used internally. This information is then…
-
Best Template for Managing Capacity of a Team
Hi everyone! We are hoping to leverage Smartsheets to help our team understand how much we have on our plates. The net net: We believe we are operating overcapacity but need an easy way to show that - especially a way to see schedules. Our team manages product launches plus a lot of product marketing projects, and we need…
-
Inventory Management
I'm looking to create a sheet to manage our department's inventory of swag/give-aways. I currently have the asset management template set up and running and am using the barcode functionality which is mostly serving our needs. The one gap I have is inventory updating. Ideally, when someone takes inventory, I would like for…
