-
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…
-
Sequential numbering not working (Project with WBS sheet)
Hi All, I am fairly new to Smartsheets, so please be kind :) I am creating a WBS with the Template the Smartsheets provides (Project with WBS sheet), but I am noticing that when I add new tasks between other already created tasks, the numbering goes all wrong. Also, Even if I add more tasks underneath, the numbering is not…
