-
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…
-
RFQ and Invoice
Hi Team, I am trying to find a template to create/form a RFQ for a customer and then turn that into an invoice. So for clarity - customer ask for a quote to build a product that has multiple steps to complete. for example: Purchase metal, cut metal, shape and form metal, weld metal, pain and ship. Steps and processes might…
-
Having 'Fun' the Smartsheet Cross Sheet References, again.
So I've set of a project template, comprising a project schedule and project cost tracking. In the project cost tracking solution there is a budget & cost tracking sheet, an invoices sheet and a cost variations sheet. The budget & cost tracking sheet pulls data from the other two. There are 8 cross sheet references in the…
-
Create your own template for Report and Dashboard
Have the option to 'File-> Save as Template' in a report or dashboard like you can do with a sheet.
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
